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?

Look for MIN function in help.


"Veronica Johnson" wrote in message
...
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?

Try this:

=INDEX(I2:R2,MATCH(MIN(I2:R2),I2:R2,0)-1)

Note that if there is more than one instance of the lowest price the formula
will return the vendor corresponding to the 1st instance of the lowest price
from left to right.

--
Biff
Microsoft Excel MVP


"Veronica Johnson" wrote in message
...
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?

On Jan 21, 2:09*pm, "T. Valko" wrote:
Try this:

=INDEX(I2:R2,MATCH(MIN(I2:R2),I2:R2,0)-1)

Note that if there is more than one instance of the lowest price the formula
will return the vendor corresponding to the 1st instance of the lowest price
from left to right.

--
Biff
Microsoft Excel MVP

"Veronica Johnson" wrote in message

...



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?- Hide quoted text -

- Show quoted text -

You are totally freakin' awesome! That worked perfectly! Exactly
what I was looking for. :)

Thanks again,
Veronica

On Jan 21, 2:09 pm, "T. Valko" wrote:
Try this:

=INDEX(I2:R2,MATCH(MIN(I2:R2),I2:R2,0)-1)

Note that if there is more than one instance of the lowest price the
formula
will return the vendor corresponding to the 1st instance of the lowest
price
from left to right.

--
Biff
Microsoft Excel MVP


You are totally freakin' awesome! That worked perfectly! Exactly
what I was looking for. :)

Thanks again,
Veronica


You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP