View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Danno[_3_] Danno[_3_] is offline
external usenet poster
 
Posts: 1
Default Row lookup based on a given value in the same row

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