hi
xl has a built in function for this. trace dependents.
right click any tool bar. from the list click formula auditing. this will
display a small tool bar. on the formula auditing tool bar, click the 4th
icon from the left. If the values in the activecell is used in any formula,
arrows will appear pointing to the cell which uses the values in the
activecell.
this may not be what you had in mind but try it and see if it's workable for
you.

Regards
FSt1

"Aman" wrote:

Lets say I have some number in cell A1. lets say, cell x4 and ab200 have
forumalas that use the number in cell A1.

If I didnt know what cell used data in cell A1 to determine its value, is
there anyway to find which cells in an excel file refer to a cell to
determine its value. I am looking for a fuction say "find_cell_reference"
which takes in the argument of a cell for which references are to be found.
so i would type something like:

find_cell_reference(A1)

and it will return something like "x4 and ab200"

Thanks