How do I match cells in different columns with words in them? I u.

[Guest]

This is an Excel Question. I use the Lookup formula to match columns but when
there is a word is doesn't work and I don't know why.
R A B C D
1 AAAAAA This Works1 AAAAAA This Works1
2 ABCDEFG This Works2 ABCDEFG This Works2
3 PEOPLE This Works3 PEOPLE Pulls value from
elsewhere in B?


Formula used in Column D: IF(+A25<>"",LOOKUP(A25,$C$1:$C$20,$B$1:$B$20),"")
How do I make this work so that no matter what the words in columns A and C
are that if they match I get the correct item from column B. In this case I'm
getting somethin like This Works99 when I want it to be Row3, Column B, This
Works3 ?

 

[Douglas J. Steele]

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

You'll stand a better chance of getting an answer if you repost your
question to a newsgroup related to Excel.