LinkBack URL
About LinkBacks
shivspatil 
Hi Gurus, I want to check if the values in the two columns are looked up considering case sensitive, NOT INDEX & MATCH, but to check if the values in the B-Column exist in A-Column. Attached the workbook.
Appreciate your solution
Shiva
Hi Gurus, I want to check if the values in the two columns are looked up considering case sensitive, NOT INDEX & MATCH, but to check if the values in the B-Column exist in A-Column. Attached the workbook.
Appreciate your solution
Shiva
Hi,
One way as an array formula entered with Ctrl-Shift-Enter in C2
Formula:
=IF(ISERROR(MATCH(TRUE,EXACT(B2,$A$2:$A$32),0)),"No match", "Match")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Rich, it works. I just put B2 in place of "Match".
Thanks a lot.
Warm regards
Shiva
Vlookup just works from left to right.
Hi Guru, I have seen it working both sides.
Vlookup only works from Left to rightOriginally Posted by shivspatil
Hi Guru, I have seen it working both sides.
Hi Guru, attached a book for your reference. Please enlighten me more !
You are only using 1 column, where is the left or right? Are you enlightened?
Or upgrade your 2007 to latest version and use PowerQuery
Thanks Sandy. I will uPGrAde...
Another non-array version:
In C2:
Enter only.
=IF(OR(INDEX(EXACT($A$2:$A$32,B2),)),B2,"No match")
Quang PT
Hey bebo021999, this too works fine. Thanks a bunch...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks