Vlookup with multiple conditions

[whitwhitsmama]

I have a document which lists patient id numbers, equipment ID, and diagnostic codes. In the document I am working on I want to return the correct diagnostic code but the correct code depends on the equipment ID. How can I accomplish this with formulas? If I use a vlookup it will return the first code found, in this example M62.81. However, in this case I need the code for RNT Nebulizer - J44.9. Both documents have both the Patient ID field and the Item ID field.


Any help would be appreciated! [TABLE="width: 392"]
<tbody>[TR]
[TD]
Example
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Patient ID
[/TD]
[TD]Item ID
[/TD]
[TD]Diagnostic Code
[/TD]
[/TR]
[TR]
[TD]E0939
[/TD]
[TD]RNT SOLACE MATRS
[/TD]
[TD]M62.81
[/TD]
[/TR]
[TR]
[TD]E0939
[/TD]
[TD]RNT NEBULIZER
[/TD]
[TD]J44.9
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Truiz]

Take a look at this tutorial this is what you need

https://www.deskbright.com/excel/index-match-multiple-criteria/