Thread: Combination IF, VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ND Pard ND Pard is offline
external usenet poster
  
Posts: 73
Default Combination IF, VLOOKUP
Use a formala similar to:

=IF(ISERROR(VLOOKUP("abc",INV Table,2,FALSE)),Q3,VLOOKUP("abc",INV
Table,2,FALSE))

Good Luck
Reply With QuoteReply With Quote