Thread: IF Function Problem Excel 2000
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
  
Posts: 340
Default IF Function Problem Excel 2000
=LOOKUP(B2,--{0,"9/1/5","1/1/6","3/1/6","6/1/6","9/1/6"},{0,1,2,3,4,5})

Reply With QuoteReply With Quote