V Lookup - Data Navigation Formula

[Rob #4]

I currently have this formula in a cell in my spreadsheet:

=VLOOKUP(C21,'LEMS Rates'!A$1:D$1303,2,0)

I am trying to figure out how to modify it based on some IF circumstances:

IF
'Cat & OH&P Markups'!A2
=
'LEMS Rates'!B1
It should use that formula

or

IF
'Cat & OH&P Markups'!A2
=
'LEMS Rates'!C1
The formula should be
=VLOOKUP(C21,'LEMS Rates'!A$1:D$1303,3,0)

or

IF
'Cat & OH&P Markups'!A2
=
'LEMS Rates'!D1
The formula should be
=VLOOKUP(C21,'LEMS Rates'!A$1:D$1303,4,0)

Could someone help me fix the formula to make this work?

 

[Joe4]

You want to structure a nested IF formula, like this:
=IF(condition1,vlookup formula1, IF(condition2,vlookup formula2, IF(condition3,vlookupformula3,what to return if no conditions are met)))

So just substitute your conditions and formulas in the appropriate places.

 

[Special-K99]

Assuming 'Cat & OH&P Markups'!A2 will be one of
'LEMS Rates'!B1
'LEMS Rates'!C1
'LEMS Rates'!D1

Try
=VLOOKUP(C21,'LEMS Rates'!A$1:D$1303,MATCH('Cat & OH&P Markups'!A2,'LEMS Rates'!B1:D1,0)+1,0)

 

[Rob #4]

That works perfect. Thank you