Thread: I need help index/match
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
cdavis cdavis is offline
external usenet poster
  
Posts: 4
Default I need help index/match

-----Original Message-----
I HAVE A FORMULA:

=INDEX(A1:B6, MATCH(C1, A1:A6,2))

ALL I GET IS #N/A



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.
In Excel 2000 and older there is no match type of 2.
What are you using and are you sure there is a match type
of 2?

Reply With QuoteReply With Quote