the column Next to

[eran3185]

hi
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 ???

[mikerickson]

Put =B1 in C1 and fill down.

[eran3185]

i want a function that give the column next to column a

[mikerickson]

Column B is the only column next to Column A.

[eran3185]

no
its just an example

[mikerickson]

I don't understand what you want to achieve.

[lucas]

Very patient Mike....I don't understand either.

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

[eran3185]

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

[Aussiebear]

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