|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup multiple values and compare different scenarios to get a specific result
In the attached sheet I want formula in column C that will give the new order quantity with following logic;
If ("Product"="Product")of column A & I, ("Closing Stock" of a particular product<"ROL" of that product) & (Current "Date" (say date in B5 if formula is being applied in C5)-Any latest previous "New Order" Date>="Lead Time" of that product) Means if it has given new order quantity once then it should not give it again within the lead time even though the closing stock is less than the ROL. For example if it gives 150 in C3 then 150 comes on or after 21.03.2014. Our formula should perform the 3rd logic only if it finds any new order qty in Array C otherwise first 2 logic are enough. Thanks in anticipation. |
#2
|
|||
|
|||
Is any body there who can help me out of the above mentioned issue.
|
#3
|
|||
|
|||
Let me take a look at it.
|
#4
|
|||
|
|||
Oy...at first blush, I think this is beyond my Excel skills. The first part, comparing the Closing Stock to ROP can be done by...
=IF([Closing Stock]<VLOOKUP([Product],[Product Data Table],2) But it's this next part that is stumping me:
|
#5
|
||||
|
||||
I suppose that if you did not get answers, your problem is not clear. Please post a sample sheet showing BEFORE and AFTER ( personally, I don't understand your requirements)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
The problem worked out finally. Sample Sheet attached.
However thanks for all the support. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - search Multiple Values (HELP!) | duskdjl | Excel | 4 | 03-28-2013 01:11 AM |
How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |
How can I retreive multiple records using a lookup? | jrpey | Excel | 3 | 11-14-2011 02:10 PM |
How to count multiple values in a single cell, except zero? | iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
Sum & difference between multiple values in a single cell | iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |