LOOKUP with 3 criteria in different sheets

Tatiana Santos

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?

Linda Manduchova

Hello @Tatiana Santos -

You may want to try the following formula:

=JOIN(COLLECT(range you want to pull in, criterion range 1, criterion 1, criterion range 2, criterion 2, criterion range 3, criterion 3), CHAR(10))

Hope this helps!

Linda