With the sample data and =vlookup() that was used in that presentation, I'm kind
of surprised that the formulat wasn't:

=vlookup(a2,key,2,false)
(added the 4th parm)

And maybe a note about changing the format doesn't mean that the underlying
value will change.

To the OP:

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()))



davesexcel wrote:

this looks like a simple lookup formula

here is a great example that shows VLOOKUP

http://www.datapigtechnologies.com/f...s/vlookup.html

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=531194

--

Dave Peterson