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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!