column search and post

[David]

Ok...i need Excel to compare data in one column to another
column and if a match is found to return the info in the
cell directly below it...can it be done...here is an
example of what i need it to do...


orginal column search column
johnson johnson
tina fred
james
tina
barbara

i need excel to return fred in another column..
then for it to search on tina and return barbara right
under fred.

 

[Ken Wright]

Assuming your two names in your Original column being in cells A2 & A3, and your
Search Column data being in B2:B6, in C2 put the following formula:-

=INDEX($B$2:$B$6,MATCH(A2,$B$2:$B$6,0)+1)

and then just paste down as necessary as far as your data in your original
column goes.

 

[David]

OMG you are my hero....thank you thank you thank you....



d

 

[Ken Wright]

My pleasure - Be aware though that if you have duplicate names in the list, you
will only get the name under the first instance showing up.