Get instant live expert help on I need help with excel if value in range

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Is in it possible in excel to identify if there are duplicate value on a range of data?
Solved by X. L. in 28 mins
Can you simplify this formula for vba? Sub Test() Dim LastRow As Long Dim i As Long LastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To LastRow If Range("A" & i).Value = "CANCELLED" Then Range("N" & i).Value = "," & Range("N" & i).Value Range("O" & i).Value = "," & Range("O" & i).Value Range("P" & i).Value = "," & Range("P" & i).Value Range("Q" & i).Value = "," & Range("Q" & i).Value Range("R" & i).Value = "," & Range("R" & i).Value End If Next i End Sub And skip if blank.
Solved by M. E. in 16 mins
In Excel if a cell equals a value in a range then the value in another cell otherwise blank Cell if A3 = 1233 look in C1:C25 range of cells for 1234 then enter the corresponding data from a range of D1:D25 into B3 A3 B3 C1:C25 D1:D25 1233 Jones, Jack 1230 Anderson, Tim 1231 Johnson, Henry 1232 Clinton, Bill 1233 Jones, Jack
Solved by O. C. in 29 mins
i need a formula where cell c3 is looking at the value in d4. if the value in d4 is in the range of .9975 and 1.0025 i want it to enter 1 in c3. if the value in d4 is outside that range i want it to simply enter the value from d4 into c3
Solved by F. J. in 16 mins
Looking for a formula for a named range, such that if ALL of the cells in the range meets ANY of these parameters: ="p", ="pass" or ="pr", then return value "PASS". If not then return value "FAIL".
Solved by T. L. in 22 mins