Try something like this:

=INDEX(1:65536,RowNum,ColNum)

example:
A1: (a row number)
B1: (a col number)

This formula returns the value of the cell at the intersection of A1 and B1
C1: =INDEX(1:65536,A1,C1)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"dgrinsh" wrote in message
...
I am working in a large spreadsheet and need to be able to find the
contents
of a particular cell. I have the row and column number but because I have
to
search about 100 16 digit numbers I find scrolling to each row laborious.
I
have seen a colleague type a formula in a random empty cell that returns
the
contents of that cell. How do I do that?