V
Veronica Johnson
On the Worksheet tab, I will ultimately have quotes from one or more
different vendors.
I want the vendor (columns i,K,M,O,Q) with the lowest price (columns
J,L,N,P,R) from the Worksheet to populate over to my Order sheet.
So the vendor from Worksheet populates the Vendor column (column G)
on
the Order sheet, and the price from that vendor populates the lowest
price column (column i). I thought I could do a VLOOKUP by
referencing the part number, but I don't know how to make it find the
lowest price in that row.
The price for each vendor is to the right. For instance, the vendor
in cell K2 would have their price in L2.
How would I do this?
different vendors.
I want the vendor (columns i,K,M,O,Q) with the lowest price (columns
J,L,N,P,R) from the Worksheet to populate over to my Order sheet.
So the vendor from Worksheet populates the Vendor column (column G)
on
the Order sheet, and the price from that vendor populates the lowest
price column (column i). I thought I could do a VLOOKUP by
referencing the part number, but I don't know how to make it find the
lowest price in that row.
The price for each vendor is to the right. For instance, the vendor
in cell K2 would have their price in L2.
How would I do this?