The above is the formula I'm using, just a little long. I'm using MSExcel'10

What I'm trying to accomplish is I'm trying to poplulate a SS with info from another SS where the exact item and correponding qty are pulled IF it meets a specified timeframe. The specified timeframe is based on dates in seperate colums, in this case columns H & N of SS-1. The formula uses this set-up date parameter to search a column of dates in SS-2 (aka SAP Data, SS-2 col AK), & once it locates a qty (SS-2, col AL) that meets the timeframe constarint from SS-1, it should populate the SS-1 formula col with the data.

However, my prob with this formula is it's pulling any qty whose item name closely resembles each other, so that's why I tried to use VLOOKUP, but once I added it to my formula was told it was too long, too many arguments.

Need some help--Please!!

Also, not sure what the formula would do if there were 2 qtys for the same exact item name--they can't both pop the formula cell, unless there's a way it can be written in the formula that the 2+ qtys can be added together---any ideas on how to accomplish that?

thank you for your expertise