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 02: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.
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.
Hello Alfred, another way,
LOOKUP(2,1/EXACT(A2,J$2:J$5),K$2:K$5)
copy down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
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.
-This is my Greek whisper to Europe.
--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.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks