VLOOKUP Help - need to return multiple values

**ktrobinson** · 10-19-2012, 12:32 PM

Is it possible to list ALL of the unique values in a series of data starting with a vlookup and return the unique values in the row?

I have attached an example of what I am trying to do:

On the visit summary tab in columns e-k I want to lookup the patient name on the charge detail tab and return only the unique values in the CPT column. So cell e3 on the visit tab for John Doe returns J1561 and I need f3 to return 96413, g3 to return 96415 and ignore the others since the codes are not unique whereas for Mr. Mister the values returned would be J2357, 96401, J0885, 96372.

Is this possible?

**Mallycat** · 10-20-2012, 01:48 AM

You should use an advanced filter (copy to another location) instead of vlookup

**e.isayev** · 10-20-2012, 04:19 AM

Hi, I think I solved your problem,
In Charge detail sheet I added one helper column,
Have a look,
I am really curious wether it is real solution of your problem

**ktrobinson** · 10-22-2012, 01:19 PM

Thanks for your suggestion Mallycat, unfortunately I have several thousand lines with hundreds of patients so the advance filter works but takes a significant amount of time to disseminate the data.