I dont really have a question as much as an insight.

Vlookup is NOT case sensitive. I know in general this isn’t a problem for most ppl using vlookup. But I had to match hundreds of ID’s and I thought i got it right w the vlookup. Then I noticed an ID like aeB300000nK was being matched with a file that’s ID was really aeB300000nk (Notice the lower case k)

So it messed up the vlookup for those .

So there are some ways to vlookup case sensitive I’m curious to know ddfers methods on doing this. One formula I found for some reason was not working using exact() and row()

Anyway, I found a cool small macro that’s does the job quite well and works just like vlookup

If anyone’s interested in the macro let me know