Populate order sheet with data from work sheet

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

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.
 
V

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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top