LinkBack URL
About LinkBacks
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:
Please Login or Register to view this content.
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.
Vlookup just works from left to right.
Or upgrade your 2007 to latest version and use PowerQuery
Hi Rich, it works. I just put B2 in place of "Match".
Thanks a lot.
Warm regards
Shiva
Hi Guru, I have seen it working both sides.
Thanks Sandy. I will uPGrAde...
Another non-array version:
In C2:
Enter only.
Please Login or Register to view this content.
Quang PT
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 !
Hey bebo021999, this too works fine. Thanks a bunch...
You are only using 1 column, where is the left or right? Are you enlightened?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks