View Full Version : the column Next to
eran3185
12-24-2007, 10:40 AM
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
12-24-2007, 10:46 AM
Put =B1 in C1 and fill down.
eran3185
12-24-2007, 11:00 AM
i want a function that give the column next to column a
mikerickson
12-24-2007, 12:03 PM
Column B is the only column next to Column A.
eran3185
12-24-2007, 12:46 PM
no
its just an example
mikerickson
12-24-2007, 12:48 PM
I don't understand what you want to achieve.
lucas
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?
eran3185
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
Aussiebear
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).
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.