p45Cal, I understand what you're saying, In the attached file called example I have a separate sheet called list. This sheet has dedicated list for names and fruit. I figured excel would be able to tell if information came from these set list.