Inverse Lookup???
 

Hi All,

Apologies if that was wrong subject line.

In Excel 2003 can I find out what other cells reference a particular cell?

Regards.
Bill.

Inverse Lookup???
 

Die Tastatur von Bill wurde wie folgt gedrückt:
Hi All,

Apologies if that was wrong subject line.

In Excel 2003 can I find out what other cells reference a particular
cell?

What do you mean by invers?

http://www.xxcl.de/5007.htm or

http://excelformeln.de/formeln.html?welcher=24
http://excelformeln.de/formeln.html?welcher=25
http://excelformeln.de/formeln.html?welcher=26
http://excelformeln.de/formeln.html?welcher=27

COMPARE = VERGLEICH
SVERWEIS = VLOOKUP
WVERWEIS = HLOOKUP
VERWEIS = LOOKUP
--
Moin+Gruss Alexander - MVP für MS Excel - www.xxcl.de - mso2000sp3 --7-2

Inverse Lookup???
 

Use the auditing toolbar to find a cell's precedents and dependecies

Excel 2003: Tools Formula Auditing Show Formula Auditing Toolbar

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Bill" wrote in message
...
Hi All,

Apologies if that was wrong subject line.

In Excel 2003 can I find out what other cells reference a particular cell?

Regards.
Bill.

Inverse Lookup???
 

With the cell selected

Tools / Formula Auditing / Trace Dependents

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Bill" wrote in message
...
Hi All,

Apologies if that was wrong subject line.

In Excel 2003 can I find out what other cells reference a particular cell?

Regards.
Bill.

Inverse Lookup???
 

Thanks Ken and Andy.

Inverse Lookup???
 

You're welcome :-)

"Bill" wrote in message
...
Thanks Ken and Andy.