How to conditionally reference a cell

[Guest]

I had this done once before and now I don't remember how I did it. It took me
a long time to find the answer the first time and now I can't seem to
remember it or find it again at all.
I have Sheet1 that has data in it. On Sheet2 I want some of the information
from a single row in Sheet1 to fill in certain cells. If I want the
information from row 5 of Sheet1, I will type 5 in Sheet2!A1. So now I want
the information from Sheet1!F5 in Sheet2 B1. So what is the correct cell
reference for Sheet2 B1? There is some way to do the Col as Sheet1!F and the
row as (A1). Any help is greatly appreciated.

 

[Ragdyer]

Try this in B1 of Sheet2:

=INDIRECT("Sheet1!F"&A1)

Where you put the row number in A1 of Sheet2.

 

[Guest]

Thanks. Works just like I need it to. I don't know why I had such a hard
time remembering that.

 

[Ragdyer]

Use it ... or lose it!<bg>

Appreciate the feed-back.