Vlookup Multiple Results

[coreyjames]

I have looked all over for a way to return a vlookup with multiple results. I have found some answers but I am looking for a different format. Please see my example below.

A1: B1:
Corey 27
Jeff 25
Taj 45
Keith 24
Corey 32

Most solutions I have found will post the data as follows:

Corey 27
32

The way I have my spreadsheet setup this will not work. I want to be able to get the results like this:

Corey 27 (1st occurance)
Tal 45
Keith 24
Corey 32 (formulas knows it already posted 27 so now it posts 32)

Thanks!

 

[coreyjames]

I got it to work but its working like a vlookup. lol. If I have case number 970716 and it returns a Hernia Repair for the procedure the next time is sees case number 970716 it returns the Hernia Repair again when it should return bowel resection.

 

[coreyjames]

Thanks very much sir. I had the formula typed in wrong and I now have it fully working but how do I get rid of the #NUM! ? Can I do an ifiserror so that they are blank if there is no returned criteria?

 

[T. Valko]

Thanks very much sir. I had the formula typed in wrong and I now have it fully working but how do I get rid of the #NUM! ? Can I do an ifiserror so that they are blank if there is no returned criteria?

What version of Excel are you using?

 

[coreyjames]

I am using 2007

 

[T. Valko]

I am using 2007

OK, try it like this.

Still array entered...

=IFERROR(INDEX(Age,SMALL(IF(Names=E2,ROW(Names)),COUNTIF(E$2:E2,E2))),"")

 

[coreyjames]

Thank you, this worked perfectly. I really appreciate you taking the time to help me out.

 

[T. Valko]

Thank you, this worked perfectly. I really appreciate you taking the time to help me out.

You're welcome. Thanks for the feedback!