CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygs-vlookup
Arya Murali
Arya Murali

Reputation: 47

to find the values

I need to find out Which supplier gives the lowest price When we have more suppliers giving the same product (Barcode). I have so many suppliers and they supply the same product. in that case i need to find out who give me the lowest price without manual lookup. Mr. @Kirkg13 gave me a solution to find out the lowest price among the latest price. Now i want to display Who gives the lowest price When we enter a barcode which is common in all suppliers.

Upvotes: 0

Views: 64

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(J2:J&K2:K, 
 SORT(SPLIT({A2:A&B2:B&"♦"&A1; C2:C&D2:D&"♦"&C1}, "♦"), 2, 1), 2, 0)))

enter image description here

Upvotes: 1

Related Questions