How do I return a cell contents in a large worksheet?

[dgrinsh]

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?

 

[Bob Phillips]

=INDIRECT(ADDRESS(row_num,col_num))

--
---
HTH

Bob


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

 

[Fred Smith]

My suggested solutions, in order:

1. Ask you colleague.
2. Use Edit>Find...
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.

 

[Ron Coderre]

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)