You said your range was A1 to F50, then your examples of the locations of
"73" was for a different range.

Try this *array* formula which I sized for your original A1 to F50.
Enter the number to find in G1.

=ADDRESS(MAX((A1:F50=G1)*ROW(A1:F50)),MAX((A1:F50= G1)*COLUMN(A1:F50)),1)
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

This will return an absolute address.
If you wish a relative address to display, change the final 1 in the formula
to a 4.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mitcheroo" wrote in message
oups.com...
A 6-column by 50-row range (a1:f50) is filled with random numbers. The
numbers are from 1 to, say, 100.

What Excel function, written in a serarate cell, will return the cell
location of the first occurence of a given number as we read the cells
from left to right and from top to bottom in the range?

(e.g., "73" occurs in cells D32, A56, B88 and F97. D32 would be the
'earliest occurence'. What operator, function or formula would report
back "D32"?)

From a college class a long time ago, I seem to recall another kind of
spreadsheet that could do that.