Hello everyone,

For a couple of weeks i've been trying to create a formula to find a
given value in a big range of numbers and give back the number in the
column next to it on the cell next to the input.

Example:

R1 | C2 | C3 | C4 |
R1 | D1 | D3 | D5 |
R2 | D2 | D4 | D6 |

When I fill D1 in cell 1, I want in cell 2(the cell next to it) the
value D3.

The lookup/vlookup/match/hlookup don't match the citeria, but maybe
there is a possibility to make a combination of those formulas?

I hope the explanation is clear and someone can help me.

Gr. Arie


--
arnoberg
------------------------------------------------------------------------
arnoberg's Profile: http://www.excelforum.com/member.php...o&userid=36187
View this thread: http://www.excelforum.com/showthread...hreadid=559612