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 ???
Put =B1 in C1 and fill down.
i want a function that give the column next to column a
Column B is the only column next to Column A.
no
its just an example
I don't understand what you want to achieve.
Very patient Mike....I don't understand either.
Eran, could you try again to help us understand what you are trying to do?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
