View Full Version : the column Next to

12-24-2007, 10:40 AM
i have a column of numbers - a , and second column - b.
i want to write a function in column c that will give the column next to 1 (cell c2 give "100" - the cell of 100 is b2 , 1 step near cell a2).
column c is In the relation to the column near column a.
maybe something with index+match ???

12-24-2007, 10:46 AM
Put =B1 in C1 and fill down.

12-24-2007, 11:00 AM
i want a function that give the column next to column a

12-24-2007, 12:03 PM
Column B is the only column next to Column A.

12-24-2007, 12:46 PM
its just an example

12-24-2007, 12:48 PM
I don't understand what you want to achieve.

12-24-2007, 03:59 PM
Very patient Mike....I don't understand either.

Eran, could you try again to help us understand what you are trying to do?

12-24-2007, 11:18 PM
i have data base.
i want a function that put on the number 100 in cell c2 by using something like "the column next to" 1 (cell a1)
for example , in cell c3 i want to get "the cell next to a3" -----> 50

12-25-2007, 03:19 AM
Permit me to butt in here but maybe this is what you are chasing? It does seem to be going about this the long way given that (=B1 in C1 and fill down) does exactly the same thing.

I have included on the second sheet a couple of examples of Index Match, one of which I downloaded from Debra Dalgliesh's web site www.contexures.com (http://www.contexures.com).