Hello, I'm trying to sort the following as attached file shows to give page ranges of specific categories. Can you guys help me with an elegant solution with formulas no vbas?
Hello, I'm trying to sort the following as attached file shows to give page ranges of specific categories. Can you guys help me with an elegant solution with formulas no vbas?
d2: =INDEX($B$2:$B$16,MATCH(C2&"*",$A$2:$A$16,0))
e2: =LOOKUP(2,1/ISNUMBER(SEARCH(C2,$A$2:$A$16)),$B$2:$B$16)
copy downwards
Match returns on first match found. Lookup returns on last match found.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
This is great, works perfect. Thank you!
No problem, glad I could help.
Oh shoot, sorry I just saw something that may be an issue. i've got two "categories" which have similar prefixes. In the attachment there is now "doe" and "do". it finds the first one fine but on the second "do" it goes back and recognizes the first instance of "doe".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks