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(+A3<"",LOOKUP(A3,$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 Works20 when I want it to be Row3, Column
B,ThisWorks3 ?