VLOOKUP

[Jack]

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

 

[Peo Sjoblom]

One way

http://www.contextures.com/xlFunctions03.html#IndexMatch2



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Dave Peterson]

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]

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!

 

[Chip Pearson]

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