How do I match cells in different columns with words in them? I u. Lee Hawken 08.09.2006 13:08:02 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 ?

Re: How do I match cells in different columns with words in them? I u. "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 08.09.2006 13:48:38 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Lee Hawken" <Lee Hawken[ at ]discussions.microsoft.com> wrote in message news:D9E73CBA-E6DD-41F2-B73E-0AF4D8EC93F6[ at ]microsoft.com... [Quoted Text] > 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 ?