LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup help. lookup result based on data in 2 columns lcc Excel Worksheet Functions 3 April 6th 10 01:20 PM
lookup based on 2 criteria SteveC Excel Worksheet Functions 1 August 7th 08 09:48 PM
A lookup based on conditions [email protected][_2_] Excel Discussion (Misc queries) 1 April 30th 08 03:19 PM
Sumproduct - Condition based on lookup of a Lookup Hari Excel Discussion (Misc queries) 12 May 31st 06 09:28 AM
lookup based on a row number chrisrowe_cr Excel Worksheet Functions 2 September 15th 05 02:18 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"