Index Match Vlookup?

[PapaDos]

Just tell me the exact address of your whole table (Systems to counties) and
the addresses of the cells containing the county to search and where you want
the result...

 

[Pete_UK]

Update on this, as the OP started another thread.

I took the risk and downloaded the file. Your formula worked well once
I had adjusted it to suit the ranges in the file and made the
correction you pointed out. Here is the amended version:

=INDEX($H$2:$H$4,SUMPRODUCT(($I$2:$N$4=C2)*ROW($H$2:$H$4))-ROW($H$2:$H$4)+1)

In the sample file the data covers H2:N4, but in reality this will go
down to row 630+.

The formula produced #VALUE if the county in column C was not present
in the reference table.

Pete

 

[IntricateFool]

Dude,

with some changes of your function and the help of Pete_UK I got it
working...

Really appreciate your help.

Thanks

in case you were wondering, I used:

=INDEX($H$3:$H$5,SUMPRODUCT(($I$3:$N$5=C3)*ROW($H$3:$H$5))-ROW($H$3:$H$5)+1)

I was getting the C3 all messed up.

 

[PapaDos]

Thanks to both of you for the feedback...