index match -

Hi Everyone, My first post here, so please excuse any shortcomings Below is my table: Item Date Quantity Amount 10010 Jul-2016 23 $32.91 10010 Jul-2016 10 $14.31 10010 Jul-2016 -10 -$14.30 10010 Jul-2016 10 $15.90 10010 Jul-2016 10 $15.90 10010 Aug-2016 3 $4.77 10010 Aug-2016 17...

I want to put discount per unit for each qty purchase for its respective category, discount is depend upon category and qty range. Discount range table <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Category Min QTY Max Qty $ Disc /unit A 1 5...

Hi I have two tabs on one workbook, as shown below. I need to look up 'Planned Cost' from Tab 2 into Tab 1 for each month .Actual cost is an manual entry. Planned cost changes every month. Tab 1: <colgroup><col><col><col><col><col></colgroup><tbody> A B C D 1 Jan-13 2 Planned...

Hello All, Thank you for your time. I am in need of your assistance in finding a better way, a more efficient non-vba way, of getting the results I get from nesting Ifs. I currently pull data from our main frame and do a visual scan. I developed a crude If statement...

I am trying to create an INDEX MATCH function which needs both a key and calendar values to lookup a value in another worksheet. SO below is the data and in the sheet to have the formula, I need to know what the value is in the Lookup table for Set2 and Mar. Can someone advise on how the INDEX...

I have data array in A2 to AF 1843 and I wish to match additional data to it which is in data array A1900 to F5066. Typically I would use a vlookup. But I need to match at least two data elements to make a correct match. Here is the function I wrote. I press the CTrl /Shift and Enter keys to...