VLookup Formula Help

[Rob0424]

Could someone help me fix this formula:

=VLOOKUP((E76,'Equip Rates'!D3:D228,0)-1,0)

I am trying to create a formula where it searched for a match to the text in Cell E76 to the Range in the "Equip Rates"!D3:D228 cells and returns the value one cell to the left when it finds the match.

 

[jtakw]

Hi,

VLOOKUP only looks to the right.

Try this:

=LOOKUP(E76,'Equip Rates'!D3:D228,'Equip Rates'!C3:C228)

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Another option would be

=INDEX('Equip Rates'!C3:C228,match(E76,'Equip Rates'!D3:D228,0))

 

[Rob0424]

I get a #N/A error using this formula?

 

[Rob0424]

This second option worked. Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.