hard20 pts · first answer countsexcelxlookuparray-formulas

Lookup on two conditions

You need the price for the product in F2 and the city in G2. Products are in A2:A900, cities in B2:B900 and prices in C2:C900. Which formula works in Microsoft 365?

A.=XLOOKUP(F2&G2,A2:A900,B2:B900,C2:C900)B.=XLOOKUP(1,(A2:A900=F2)*(B2:B900=G2),C2:C900)C.=XLOOKUP(F2,A2:A900,C2:C900)*(B2:B900=G2)D.=XLOOKUP(F2,A2:A900,C2:C900)+XLOOKUP(G2,B2:B900,C2:C900)

Discussion 0

Join free to post in the discussion.

Lookup on two conditions

Discussion 0

Related questions