How to conditionally reference a cell
 

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.

How to conditionally reference a cell
 

Try this in B1 of Sheet2:

=INDIRECT("Sheet1!F"&A1)

Where you put the row number in A1 of Sheet2.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike_n_TX" wrote in message
...
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.

How to conditionally reference a cell
 

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

"Ragdyer" wrote:

Try this in B1 of Sheet2:

=INDIRECT("Sheet1!F"&A1)

Where you put the row number in A1 of Sheet2.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike_n_TX" wrote in message
...
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.

How to conditionally reference a cell
 

Use it ... or lose it!<bg

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike_n_TX" wrote in message
...
Thanks. Works just like I need it to. I don't know why I had such a hard
time remembering that.

"Ragdyer" wrote:

Try this in B1 of Sheet2:

=INDIRECT("Sheet1!F"&A1)

Where you put the row number in A1 of Sheet2.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Mike_n_TX" wrote in message
...
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.