Hello
Is there any way to make MATCH and VLOOKUP case-sensitive?
For example, I want VLOOKUP to look up "art" and not "Art" in a column.
Hello
Is there any way to make MATCH and VLOOKUP case-sensitive?
For example, I want VLOOKUP to look up "art" and not "Art" in a column.
There are a few approaches - assume lookup values in A with values to be returned in B ... criteria is in C1 with result formula in D1:
D1: =INDEX(B1:B100,MATCH(TRUE,INDEX(EXACT(A1:A100,C1),0),0))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Try this
=IF(EXACT(E2,VLOOKUP(E2,Buildings!$E:$E,1,FALSE)),VLOOKUP(E2,Buildings!$E:$E,2,FALSE),"No Exact Match"
Basically you are writing the formula to find the Exact match first in column(1). If an exact match is found then Vlookup and place the contents of coulumn (2). If match found but not exact place "No Exact Match" in the cell.
Note if there is nothing found at all in the range the result in cell will be #N/A.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks