Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
HOW DO I AUTOMATICALLY POPULATE AN INVOICE ON SHEET 2 FROM SHEET 1 | Excel Discussion (Misc queries) | |||
How to populate prices in sheet two based on cost in sheet one | Excel Worksheet Functions | |||
How to populate one sheet with data from another sheet | New Users to Excel | |||
populate cells with data from another sheet | Excel Worksheet Functions |