Thread: 'IF','LOOKUP' or 'HLOOKUP'?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajan Iyer Rajan Iyer is offline
external usenet poster
  
Posts: 4
Default 'IF','LOOKUP' or 'HLOOKUP'?
Arvi,

Good Job, the solution worked.
--
Rajan


"Arvi Laanemets" wrote:

Sorry!


F2=INDEX($A$1:$D$1,,MATCH($E2,$A2:$D2,0))



Reply With QuoteReply With Quote