Thread: Multiple If's and OR's
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shelly Shelly is offline
external usenet poster
  
Posts: 84
Default Multiple If's and OR's
GOT IT!

Found this in another post:

=IF(ISNA(MATCH(A1,Sheet1!$A$1:$A$300,0)),"",INDEX( Sheet1!$B$1:$B$300,MATCH(A1,Sheet1!$A$1:$A$300,0)) )

Reply With QuoteReply With Quote