VLOOKUP? Locate specified text in column, return result X
Posted by Kevin on January 23, 2002 2:08 PM
I want a lookup in column U, to look in column Q through a string of text such as (RETAIL,CG,6 TO 10 STORES, ONLINE SALES SUITE-YES, GROSS ANNUAL SALES - $5 TO $10 MILLION, FC,GA,WIRELESS COMM, BJ)
and if the text "gross annual sales - $5 - $10 million exist in that row, return the value "X" in column U, but I am having no look in getting the lookup to work. Any suggestions guys and gals??