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.

Please Login or Register  to view this content.

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