Excel: Find value in a table on different workbook and return column value

This one is a little tricky for me, I've tried a lot of formulas but none of them have returned the value I am looking for. I have a value in spreadsheet 1 called "99213" I have a table in spreadsheet 2: A B 1 Ambulatory 99201, 99202, 99203, 99204, 99205, 99211, 99212, 99213 2 Immunization 90698, 90700 3 Diabetes 83036, 83037, 3044F, 3045F, 3046F In column B of Spreadsheet 2, there are multiple values separated by a comma. The value I want to return for this example is A1: Ambulatory. Is there a simple way to do this? A vlookup isn't working for me. Any help would be greatly appreciated!!

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of May 27, 2015.

For more resources for Microsoft Excel