Indirect function, referencing another worksheet

[dowell89]

Bit of a tricky one to explain, (probably easy to see with the attached workbook)

On sheet 1 in column A I have all the cell row values that I require.

Using these values in column A (sheet 1), I would like to use them in a formula referring to a cell in column A (sheet 2). With the output on sheet 1.

Normally I would just use the INDIRECT function, but I only have the row values in the boxes (derived using other formula). I know I could go through and add "A" in front of all the values but this is time consuming.

[ragulduy]

I'd assume:

=Indirect("Sheet2!A" & A7)

in B7 and copy down.

[XOR LX]

Hi,

You don't need iNDIRECT for this. Simply (in B7 and copy down):

=INDEX(Sheet2!$A:$A,Sheet1!A7)

Regards

[dowell89]

Thats really obvious, I feel like bit of an idiot.

Cheers