Thread: Index function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shirley Shirley is offline
external usenet poster
 
Posts: 31
Default Index function

Can you use the match function to return the last match instead of the first?
I know the match type 0 returns the first exact match. I tried using the
match type number that was the same as the quantity of entries to return the
last exact match, but I get an error. Does match type only accept -1, 0, and
1??
--
Shirley