Thread: Help writing a lookup formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Help writing a lookup formula
Kevin,
In C8:
=INDEX(C4:C6, MATCH($O8,$O4:$O6,0))

Copy accross.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote