View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AZSteve AZSteve is offline
external usenet poster
 
Posts: 31
Default Get location of match in another worksheet

"Workbook A/worksheet A" contains a reference cell with a date (formatted
date number). I need a formula for this worksheet that gives the cell
address in range B1:G65 of "workbook B/worksheet C" that matches the contents
of the reference cell. Some of the cells in B1:G65 of workbook B/worksheet C
contain date numbers and one will match. I will use that address to import
data from cells below the matching cell.