Thread: Formula using 2 points of reference to return a value from a table
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Formula using 2 points of reference to return a value from a table
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()))

MrvinGover wrote:

Do you have any good direction to point me in which to learn more about
the Index and Match functions? The excel tutorial is a little weak.

--
MrvinGover
------------------------------------------------------------------------
MrvinGover's Profile: http://www.excelforum.com/member.php...fo&userid=5124
View this thread: http://www.excelforum.com/showthread...hreadid=490253

--

Dave Peterson
Reply With QuoteReply With Quote