If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|