View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Lookup Data based on 2 search criteria

Excel 2007
Lookup in an array with merged cells.
Three search criteria.
Three solutions.
Date and update issue not addressed here.
http://www.mediafire.com/file/kmkmwktmuiy/03_10_09.xlsm