Find Content of cell refernece

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

egan006@gmail.com - 01 Mar 2007 09:38 GMT

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

Reply to this Message

Niek Otten - 01 Mar 2007 11:34 GMT

Hi Brendan,

Use the INDIRECT() function

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
| I want a formula that finds a cell and returns it address in another
[quoted text clipped - 10 lines]
| Thanks
| Brendan

Reply to this Message

egan006@gmail.com - 01 Mar 2007 11:56 GMT

Thank for thats works great

> Hi Brendan,
>
[quoted text clipped - 22 lines]
> | Thanks
> | Brendan

Reply to this Message