Thread: How can I lookup when match has more than one value?
View Single Post
  #49   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah Sarah is offline
external usenet poster
  
Posts: 231
Default How can I lookup 2 values in order to return 1?
Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to
lookup 2 different dates in a table and if both of those dates appear on the
one sheet, I need the associated value to be returned. If this is possible,
how would I do this?

Reply With QuoteReply With Quote