Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default VLOOKUP
Hi All,
Could someone please tell me why this formula is unacceptable?
=VLOOKUP(A1,{5,(A1+1);10,(A1+2);20,(A1+3)},2)
Regards - Dave.
Reply With QuoteReply With Quote