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?

=INDIRECT(ADDRESS(row_num,col_num))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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?

My suggested solutions, in order:

1. Ask you colleague.
2. Use EditFind...
3. If you want the row number, use the Match function.
4. If you want the contents of the cell, use the Vlookup function.

Regards,
Fred.

"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?

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?