View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default Lookup 2 values 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 one
sheet, I need the associated value to be returned. If this is possible, how
would I do this?