Using cell results as cell reference in formulas

[bigmantitus]

I have a formula that returns a column letter (i.e. AB) in cell BK7. Is there a way to put this result in another cell reference (to be used in formulas like vlookup). For example:

=$BK7$10

would yield the value in AB10.

Thanks.

[Ace_XL]

Use INDIRECT function

hence,

=INDIRECT(BK7&10)

[bigmantitus]

Ace - Thanks for the quick reply! That definitely works. The next question is how to put this into a formula that uses data from another worksheet. 'Sheet1' cannot be followed by the INDIRECT function.

[Ace_XL]

try..

=INDIRECT("Sheet1!"&BK7&10)

[bigmantitus]

That works well. Is it possible to use two INDIRECTS. For example, INDIRECT("Sheet1!"&BK7&6):INDIRECT("Sheet1!"&BK7&1101) to get a range (with the semi-colon). I was unable to get something like this to work.