offset

[Pete]

need soem help.
user types in a value in a1

in b2 i want to display the results

in a3:a50 i have the data i want to display in b2
corresponding to the number entered in a1

how is this done?

so if 13 is entered in a1 then i want to display
want b2 to equal what is in cell a13

 

[Domenic]

Hi Pete,

If I understand you correctly, try,

=OFFSET($A$2,$A$1-2,0)

Hope this helps!

 

[RagDyeR]

Try this in B2:

=INDIRECT("A"&A1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


need soem help.
user types in a value in a1

in b2 i want to display the results

in a3:a50 i have the data i want to display in b2
corresponding to the number entered in a1

how is this done?

so if 13 is entered in a1 then i want to display
want b2 to equal what is in cell a13

 

[Leo Heuser]

Pete

In B2:

=INDIRECT("A"&A1)

will do the job.

 

[Luke McTighe]

Try this formula in cell B2
=INDIRECT(CONCATENATE("A",A1))

 

[Soo Cheon Jheong]

Hi,

=IF(AND(A1>=3,A2<=50),OFFSET($A$1,$A$1-1,0),"")

or

=IF(AND(A1>=3,A2<=50),INDIRECT("A"&A1),"")

--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--

 

[Pete]

Your first example worked great. Thanks!