If A1 = 8, then
=INDIRECT("B"&A1)
would return the value of cell B8.


However, given the *exact* scenario you describe.("return the value in colB
where colA = x"), you could use Vlookup.

- D1 holds your LookupValue
- A2:B10 holds your table of values
- some other cell: = VLOOKUP(C1, A2:B10, 2, FALSE)
This would return the value from column B of your table where column A
exactly matches LookupValue. Column A does not need to be sorted.

--
HTH,
George


"$andsense" wrote in message
...
I want to have a cell retrieve contents from another cell using the IF
function, but I need it to be variable. For instance, I want a cell to
receive contents from cell B2, if contents of another cell are A2, and if
the
contents of that same cell are A3, then I want the B3 to show up, A4 - B4,
etc.

Is there a way to use a number placeholder like =IF($B$3=A$'x',B'x') where
'x' represents the number that I want to vary?

Thanks,