Thread: [Solved] Search with multiple strings
View Single Post
 
Old 03-02-2013, 03:45 PM
silverspr silverspr is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Apr 2011
Posts: 24
silverspr is on a distinguished road
Default

HI
thanks for the new idea, works on a sorted list w/the [match_type] left off. You'd think an exact match would work!

And I realized afterward, I can use the index function to find the rank negating the need for the vlookup.

d
Reply With Quote