| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.links
|
|||
|
|||
|
Inverse Lookup???
Thanks Ken and Andy.
|
|
#6
Posted to microsoft.public.excel.links
|
|||
|
|||
|
Inverse Lookup???
You're welcome :-)
"Bill" wrote in message ... Thanks Ken and Andy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inverse Table Lookup | Excel Worksheet Functions | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
