When text is entered in Column A, I want Column B to lookup the list in Column F and return either TRUE (it's in the list), or FALSE (it's not there). And it has to be an exact text match. The other formulas I have tried return TRUE even if it's just a character match.
Last edited by quade_1; 07-15-2010 at 10:21 PM.
Perhaps
=IF(ISNUMBER(MATCH(A1,F:F,0)),EXACT(A1,INDEX(F:F,MATCH(A1,F:F,0))),FALSE)
where A1 is being matched to column F
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=SUMPRODUCT(--EXACT($F$1:$F$100,A2))>0
i think the match will fail if any above above it are the same but a different case
Last edited by martindwilson; 07-15-2010 at 09:35 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Fantastic, thank you so much!!Originally Posted by NBVC
i really think you should look at this before you go on! match only checks the first instance it finds. but if you only have one instance and you are just checking case youd be ok
Dear Sir
I maintain different ledger sheet for accounting purposes. Maintaining all ledger sheet it became trouble for me. I want that all ledger will link with cash where i entry one voucher automatically it will transfer to that ledger sheet. That means cash related expenses and income will link that account. I will entry in cash book opposit account will reach to that ledger.
If any excel page remain in you Please send my [email protected].......
Welcome to the forum!
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Thread closed.
Last edited by AliGW; 11-05-2016 at 02:24 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks