See the "Double Lookups" section at
http://www.cpearson.com/excel/lookups.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.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