column search and post

  • Thread starter Thread starter David
  • Start date Start date
D

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.
 
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.
 
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.
 
Back
Top