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,

Sounds like a VLOOKUP.
--
David Biddulph

"$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,

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,

Hmmm, I think you might be right - if I can just figure out how to use it?

"David Biddulph" wrote:

Sounds like a VLOOKUP.
--
David Biddulph

"$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,

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

--
HTH,
George


"George Nicholson" wrote in message
...
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,

Once I figured this out it worked well. Thanks for the help Biddulph

"David Biddulph" wrote:

Sounds like a VLOOKUP.
--
David Biddulph

"$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,

Got it - this worked well. Thanks for the help!

"George Nicholson" wrote:

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

--
HTH,
George


"George Nicholson" wrote in message
...
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,