I am looking to build a macro which searches within a cell for one of multiple possible values and returns the value found, if any. Specifically, this macro will search within the Transaction column of banking detail and return vendor information from the inquiry search table.
Column A contains Transactions from the bank. Row 1 Column A contains "1/1/16 Amazon 564654654." Row 2 Column A contains "1/15/16 Barnes Nble 5054056." Row 3 Column A contains "1/20/16 65456Dry Queen."
Column B contains the table the search will reference. Row 1 column B contains "Barnes." Row 2 column B contains "Dairy." Row 3 column B contains "Amazon."
This macro needs to search in cells A1:A3 and return the match from cells B1:B3. From there it will use a Vlookup to search in cells C1:C3 for the full name of the vendor (i.e. "Dairy Queen." "Barnes & Noble.")
How should I go about writing this?