Most valuable professional
  • Hot Topics

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

  • Excel
  • Microsoft Excel