How do Icorrectly use the LookUp feature when the cells contain wo
 

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 ?

How do Icorrectly use the LookUp feature when the cells contain wo
 

"Lee Hawken" skrev i en meddelelse
...
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 ?




Hello Lee

C1:C20 must be placed in ascending order.
Maybe that's the problem?

--
Best regards
Leo Heuser

Followup to newsgroup only please.