How to use Vlookup-Case sensitive

**Terressa** · 07-15-2015, 12:44 AM

Hello

I want to lookup "SAND" not from "sand" in a column so is there any way to use the Match along with vlookup in case sensitive.

Thanks
Arpita

**NeedForExcel** · 07-15-2015, 12:54 AM

Maybe something like this?

=INDEX($B$1:$B$3,MATCH(1,FIND(D1,A1:A3,1),0)) - Commit using Ctrl+Shift+Enter

See the file attached

**quekbc** · 07-15-2015, 12:55 AM

If you're talking about the MATCH function, you can use this.

=MATCH(1,--EXACT(A1:A100,"SAND"),0)

This is an array function and as such, you'll need to hold CTRL and SHIFT before pressing ENTER

**cbatrody** · 07-15-2015, 02:57 AM

Try the following formula in E1:

=SUMPRODUCT((EXACT(A$1:A$5,D$1)*(B$1:B$5)))

Re: How to use Vlookup-Case sensitive