How do I match words in Column A and C in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to do a comparison on my excel sheet. I have 4 columns and I need to
compare the single words in column A to match the single words in column C
and the single word in Column D on the respective row. Is there a formula to
do this?

eg it starts like

1 Dog Tail Bird Tweetypie
2 Cat Tail Dog Rover
3 Bird Feather Cat Tom


but ends up looking like

1 Dog Tail Dog Rover
2 Cat Tail Cat Tom
3 Bird Feather Bird Tweetypie

I have looked at vlookups to be honest dont fully understand what is being
said, so if anyone can help explain it even plainer or another way to do it
that would be superb

thanks
 
I want to do a comparison on my excel sheet. I have 4 columns and I
need to compare the single words in column A to match the single words
in column C and the single word in Column D on the respective row. Is
there a formula to do this?

eg it starts like

1 Dog Tail Bird Tweetypie
2 Cat Tail Dog Rover
3 Bird Feather Cat Tom


but ends up looking like

1 Dog Tail Dog Rover
2 Cat Tail Cat Tom
3 Bird Feather Bird Tweetypie
Click to expand...

Maybe the following would help.

In E1 put
=IF(COUNTIF(C:C,A1)>0, A1,NA())

In F1 put
=VLOOKUP(A1,C:D,2,FALSE)

Copy the two cells downward for as many rows as you need.
 
Back
Top