index & match

Hi all, I am trying to do an index match with multiple criteria, but not to return an exact value and I'm having trouble doing it. Can anybody help? The idea is the following: I need to find the payment value (column B) for occurence #55 in IL If there was no "state" column, I would use the...

I need a formula that will sum together the values of the 4101, 4119, and 4122 that are labeled March in row 9. I can get it to return the first value the index match throws back, but I am having trouble adding the sum formula into it. Help would be much appreciated.

Hi I have reached the edge of my knowledge and need some assistance. I have a sheet that tracks crops and input chemicals, I need to summaries this into a table so that I can budget the cost based on the month the item is consumed. In Sheet 1. Data The first few columns are for the row...

Hello Struggling to get a Vlookup or an Index with Match to lookup a table of data in one workbook and get any corrresponding data from the other. I have a list of products in my first workbook which has monthly units sold in it. The second workbook has a manually copied Pivot Table of...

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...

Hi all I have the following sheet and I'm trying to use an index and match fomrula but it ignores a dynamic value. In colum O13, I'm using the index and match to return the person with the lowest value. This works as intended but I need a way to continue this but to ignore the name/person from...

I have one excel file that has two tabs that i want to work together. In Tab1 i want the priority list to be updated manually. Then on tab2 i want the priority list to be filled automatically from tab1. The order numbers will be in different sequence on both tabs so i want the priority to...

I have a dataset shown below that is used for production scheduling. I would like to be able to look up by the bay number and the date and return the job # and the phase that the date falls in. If I reorganize the data, I can use an index match and concatenate function. However, the scheduler...

hello, I want to use the index and match formula but with 2 adjacent arrays (OH & OJ), is there a formula that I can add ? please help 😄

Hello All, I am trying to get a Index Match formula to work on my sheet Currently I am trying to use the following but its not working. =INDEX(NewDemand!$A$1:$CA$55,MATCH($C$1,NewDemand!$A$1:$A$55,0),MATCH($E18,NewDemand!$A$1:$CA$1,0),MATCH($O$1,NewDemand!$Q$1:$Q$55,0)) First Sheet...

Hi there, I have an index match match 2-way look up, which returns data based on another tab. (The index match does a vertical look up and then a horizontal one). The formula works fine, but I would like to introduce a variable into the formula to so it looks up the 'correct' tab, corresponding...

Hello, I'd like to do a multiple criteria lookup to find the cost per unit of a book. I'd normally use Index and match to do this but I'm having trouble because one of my lookups is not exact and is in a range. I tried doing boolean logic with an xlookup, but I can't get it to work unless...

Hi there. Can anyone help me with an indirect with nested index match formula that's dynamic enough to allow me to get values from other sheets which change depending on the Factory and Metric I need them for? My hope is to have one formula that's dynamic to copy it across and down as the file...

Hi everyone. I have two sheets: (A) master sheet and (B) single store sheet (examples below). I'd greatly appreciate your help with two things: A Formula that dynamically populates rows 2-15 of Col B on "Store 1 Sheet" I tried this but it's off by one row... I think it's treating the "Store...

Hello, I am trying to figure out a formula to work out the cost of ingredients in different stores and then also look at the cost for the whole recipe at the same time. I have an example with really basic amounts in it just to give an idea. I have built it with a really basic =(A1 * I1) + (A2...

Hi all, I am attempting to extract full columns of values only when the column header cell contains specific text in a large matrix where those headers are repeated (due to testing under multiple conditions.) I have attached an example sheet. I would like to make the measures contiguous (e.g...

Hi there, I am looking for a formula which can lookup the text in cell S7 and match this with the range of options in the range U3:U20. I would then need the formula to check the table range V3:AG20 for the cell which contains the percentage figure and then return the date in row 2 into cell...

I've looked over some posts here related to my issue, but can't seem to get this to work. I want to use Index/Match using VBA to find a specific cell value in a named range. Dim myDistro As String Dim myID As Integer myDistro = Application.WorksheetFunction.Index(Worksheets("PS Console -...

Hi, I am looking to obtain an overall itemised count from a delivery taken from the scanned barcodes. The first image is the full inventory catalogue at where the items are looked up against. ABCDEFGH1ItemPart numberTests Per Kit ( tests x cartridge )2Amylase reagent4T8520640 (160x4)The full...

Hi! I'm currently working on a project where I have to match a reference number to one number from a separate column that is within +/-3 of the reference or equal to the reference. What formula can I use to do this?