Reverse VLOOKUP - unable to get it to fire

[abcdeabdce]

Hi There -

I'm having trouble getting my reverse vlookup to fire.

What I'm trying to do:

I have (2) VLOOKUPS in Column G of tab "Calculations" checking the same column (D) in two different sheets. If a value is a found in Column D, I need to return the value of Column A. However, I'm unable to get the formula to fire.

Can anyone see if I'm doing anything wrong?

[protonLeah]

There's no formula

[LeoTaxi]

For G2

Please Login or Register  to view this content.

Kind regards
Leo

[jtakw]

Hi,

If I understand correctly, you are checking if the Plate belongs to either Monthly or Member, if so, return the Name:

=IFERROR(IFERROR(INDEX('HCC Monthly Parking Pass'!A:A,MATCH(A2,'HCC Monthly Parking Pass'!D:D,0)),INDEX('HCC Member Parking Plate'!A:A,MATCH(A2,'HCC Member Parking Plate'!D:D,0))),"No Match Found")