One way

http://www.contextures.com/xlFunctio...ml#IndexMatch2



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Jack" wrote in message
...
how do you create a Vlookup table that uses two references to get the
correct
information, can this be done using a vertical reference and a horiziontal
reference to locate the correct cell. I think I have seen this before but
cannot remember where
--
Jack