Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns.
Here's a simple explanation of what I'm having trouble with
I have a table with
SUPPLIER A
- F4: PRICES SUPPLIER A,
- G4: SUPPLIER A NAME,
- H4: LEAD TIME SUPPLIER A,
- I4: BRAND SUPPLIER A
SUPPLIER B
- J4: PRICES SUPPLIER B,
- K4: SUPPLIER B NAME,
- L4: LEAD TIME SUPPLIER B,
- M4: BRAND SUPPLIER B
SUPPLIER C
- N4: PRICES SUPPLIER C,
- O4: SUPPLIER C NAME,
- P4: LEAD TIME SUPPLIER C,
- Q4: BRAND SUPPLIER C
On the first Table I need to get the SMALLEST price provided by the 3 suppliers, and save on the COLUMN MINUMUM PRICE B4:
B4: The smallest price from the 3 suppliers
C4: The consecutive 2nd column from the supplier selected with the SUPPLIER NAME (The name of the supplier with lower price)
D4: The consecutive 3rd column from the supplier selected with the SUPPLIER LEAD TIME (The lead time of the supplier with lower price)
E4: The consecutive 4rd column from the supplier selected with the SUPPLIER BRAND (The brand of the supplier with lower price
See atached screenshot for more details
Minimum Price.png
Bookmarks