I want to sort my spreadsheet using the venod me. however not all lines have
vendor name. Rather, the vendor name is within the text in column a. Usually
in the middle. Is there a way to do a vlookup and say the vendor name of all
in column a that contains the word 'elite' is "Elite Services?

If I do a vlook up, what should be the formula. If it's not possible in
vlook up, is there anyway i can do this.

thanks,
del