Hi Guys,
I'm new to excel and Im stuck with a problem I have some case sensitive data that I need to vlookup but it just wont do a case sensitive vlookup?
can someone please show me how to do this?
I've attached the file below thanks.
Cheers.
AlfredCaseSensitiveVlookup.xlsx
Last edited by alfykunable; 12-23-2011 at 01:41 AM.
Try:
=INDEX($K$2:$K$5,MATCH(TRUE,INDEX(EXACT($J$2:$J$5,A2),0),0))
or
=SUMPRODUCT(--(EXACT($J$2:$J$5,A2)),$K$2:$K$5)
copied down.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Hello Alfred, another way,
LOOKUP(2,1/EXACT(A2,J$2:J$5),K$2:K$5)
copy down.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Originally Posted by Haseeb A
works really well
Hello.
Just out of curiosity I ask ..
The formulas of NBVC, not work for you???
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks