alan

check the below link, maybe you could understand it better than me & come up with a solutions for me. thanks

Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions - YouTube