indirect referencing

S

stephen.reading100

I've been using indirect for quite a bit of referencing in a workbook. Now I
want to use t2 cells in 1 sheet as the references to a cell in another
sheet. I've used 1cell from the current sheet and the column from the sheet
I'm referring to up to now.
=INDIRECT("SHEET1!E" & T349)

Don't know how to use to correct syntax to do something like

=INDIRECT(SHEET1! B2 & T349)

where B2 and T349 are from sheet 2

any help appeciated as it's driving me mad.

Steve
 
D

Dave Peterson

I'm kind of confused about what B2 and T349 contain, but I put:

A in sheet2!B2
and
7 in sheet2!T349

And used this formula:

=INDIRECT("SHEET1!"&Sheet2!B2 & Sheet2!T349)

it retrieved the value in sheet1!A7
 
Top