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

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

Maybe you saw =index(match())

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Jack wrote:

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

--

Dave Peterson

thank you guys for the quick reply It might take me some time to understand
but it looks to be just what I need.
cheers!
--
Jack

"Dave Peterson" wrote:

Maybe you saw =index(match())

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Jack wrote:

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

--

Dave Peterson

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