Combine of IF function and Index function with two different tables

New Contributor

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 table with one condition.

Ex: There is 5 different vessels namely A,B,C,D,E these vessel having two different thickness value (Group I Thickness & Group II Thickness), now the condition is "a" is less than or equal to 0.002 use Group I Thickness otherwise use Group II Thickness values. From the dropdown if I select the vessel name the corresponding thickness value will be display in Final thickness cell.

I have attach the workbook for your further reference.

Please suggest me the best answer to complete this workbook am awaiting for your valuable suggestions.

 

Thanks

Rajaram V

3 Replies

@Rajaram7584 

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