Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am in the process of creating a quote book that pulls informatio into one sheet that we give to our customer. With in this book ther is a sheet where we enter in all of our vendor returns in the followin colums (as a side note we have 10 vendors we get info from. So all colums are multiplied out 10 times on the same row.): Qte Qty 1 Price Qty 1 Qte Qty 2 Price Qty 2 MPQ LeadTime I want to find the MPQ that goes with the minimum Price Qty 2. I have used the Min function to locate the minimum Price Qty 2. I a trying to locate the MPQ based on the min price QTY for each item. I am not sure how else to explain this. If there any questions let m know. Thanks in advance. Dan Dodso -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
lookup based on 2 criteria | Excel Worksheet Functions | |||
A lookup based on conditions | Excel Discussion (Misc queries) | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
lookup based on a row number | Excel Worksheet Functions |