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!! Last edited by Mhalle; Yesterday at 01:25 PM.
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:
This article includes the following tags:
- Microsoft Excel