Forum Discussion
Combine of IF function and Index function with two different tables
Dear Friends, Good Day, I have query with combination of IF function and Index function. I have prepare a worksheet regarding with my workplace. I need to select the value from two different t...
=VLOOKUP(D3,D9:F13,IF(E6<=0.002,2,3),FALSE)
Is this what you are looking for? I entered a dropdown in cell D3 to select either A, B, C, D or E.
Dear Quadruple_Pawn, Can you please explain the formula mentioned above?
I can understand the VLOOKUP(D3,DP:F13,IF(E6<=0.002... After that "2,3 & false" I can not understand. So please explain me.
I can understand the VLOOKUP(D3,DP:F13,IF(E6<=0.002... After that "2,3 & false" I can not understand. So please explain me.