Find Content of cell refernece

  • Thread starter Thread starter egan006
  • Start date Start date
E

egan006

Hi
I want a formula that finds a cell and returns it address in another
workbook

I have the formula to return the address but it will not return the
content of the address

=ADDRESS((MATCH(J8,master_ROI_Overdrafts_autograding.csv!$A:$A,0)+1),
1)


I'm sure this is nice and easy but its 9 in the morning

Thanks
Brendan
 
Hi Brendan,

Use the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
| I want a formula that finds a cell and returns it address in another
| workbook
|
| I have the formula to return the address but it will not return the
| content of the address
|
| =ADDRESS((MATCH(J8,master_ROI_Overdrafts_autograding.csv!$A:$A,0)+1),
| 1)
|
|
| I'm sure this is nice and easy but its 9 in the morning
|
| Thanks
| Brendan
|
 
Back
Top