Try something like this:

A1 = B
A2 = 4
B4 = Yes

=INDIRECT(A1&A2)

result = Yes

--
Biff
Microsoft Excel MVP


"Tigerxxx" wrote in message
...
Hello,

Is it possible for me to make the column as well as the row portion of a
reference cell variable?
Example- If the reference is to cell B4, can I make "B" as a variable
using
a formula as well as make "4" as a variable using a formula?

Please advise.
Thank you.