Vlookup with multiple criteria

[coreyjames]

I am currently working on a project for a hospital where I have data with case numbers, procedures, cost, etc. I have a vlookup looking at a pivot table that is matching the case number with the procedure. The problem is I have instances where the case number may be 789987 and a bowel resection was the procedure. However, there may have been multiple procedures for one case so the same case number "789987" may appear again with a different procedure like a hernia repair. I want to make sure if my vlookup picks up "bowel resection" the first time it sees the case number then it will pick up the other case "hernia repair" the second time it sees the number. Is this possible? Thank you!

 

[kidwispa]

This may help...

http://www.mrexcel.com/forum/showthread.php?p=2329977#post2329977

 

[coreyjames]

I looked at the thread but I dont think thats what I am looking for.

case #: 12345 Bowel Resection
case #: 5678 Surgery
case#:12345 Hernia repair

I need the vlookup to return just the procedure name but when it sees the case "12345" it will say bowel resection both times instead of bowel resection and then hernia repair next time it sees it.

 

[kidwispa]

Apologies for the misunderstanding... you're looking for vlookup with multiple results, not criteria...

Having just done a quick google search I've found the following possible solution that might help...

http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/

That seems to give the right answer you're looking for...