Populate order sheet with data from work sheet

[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?

 

[Gaurav]

Look for MIN function in help.

 

[T. Valko]

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.

 

[Veronica Johnson]

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










- Show quoted text -

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

Thanks again,
Veronica

 

[T. Valko]

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.

[/QUOTE][/QUOTE]

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

Thanks again,
Veronica
You're welcome. Thanks for the feedback!