How to look up base on 2 criteria?

[Royhe380]

There are columns of client PO and product, PO column has duplicated as different products are in the same PO, and product column also has duplicated as same are ordered in different POs, how can I lookup a data base on PO and product columns?
Thanks

[#2 · Accepted solution]

@Royhe380 

Depends on your Excel version, e.g.

=XLOOKUP(1, (PO=myPO)*(product=myProduct), somethingToReturn, "can't find")

[#3]

Awesome! Cheers!

[#4]

@Royhe380 , glad it helped