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. - Thanks Quadruple_Pawn
I get the answer what I'm expecting.
you have using Data Validation method for drop down facility,
This function can use Combo Box (Form control) method for drop down?
As you ask, A,B,C,D & E are the vessel names. If I select the vessel name the corresponding thickness value will be display on particular cell.
Thanks
