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.
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
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