Hey I would really appreciate if someone could help with this. I'm trying to use vlookup to items from a master list that have the word "dress". THe formula that I am currently using is VLOOKUP("*"&E5&"*",'Overall Summary'!A5:D1427,2,FALSE)...where E5 is the word dress, "overall summary" is the master list. The problem I keep on encountering is that the formula is grabbing the same item every single time. Is there anyway I can have the formula research the list if it encounters a duplicate? Let me know if this doesn't make any sense. Any help would be great