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

[Legacy 327817]

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!!

 

[gmrush]

I think so. Try to provide a small sample (of only what is relevant) along with the expected results. Please do not discuss any formula and more than one problem at a time.

The relevant information is posted in my original thread. I did not want to "muck" up this thread with that information.