If variable, then variable

$

$andsense

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,
 
G

George Nicholson

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.
 
G

George Nicholson

some other cell: = VLOOKUP(C1, A2:B10, 2, FALSE)
typo: should be D1, not C1
 
Top