LOOKUP with 3 criteria in different sheets
I have a "template A" where we collect all the PO numbers by different Country, Vendor name and Payer.
In "template B" I want to create an automatic search function for the corresponding PO according to information in the 3 cells of the columns Payer, Country and Vendor.
I understand that it would be the equivalent to VLOOKUP with 3 criterias -> information contains in the Payer cell, Country cell and Vendor cell with formula in the PO number cell but I can not create it.
Could someone help me?
Help Article Resources
Check out the Formula Handbook template!