index & match

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?

Hello. This is round 2. I posted the question yesterday, and got a terrific response, but i neglected to mention one thing - The current formula is incredible, but works on a row by row basis. Index/Match - Return value if partial text from cell contained in separate column however, I forgot...

All this works correct except for the Index match method say`s run time error 438? Anyone know why? Option Explicit Sub VLookup() Dim SrcReD As Workbook, Alton As Workbook, Cov As Workbook, Basildon As Workbook, wb As Workbook, BName As Workbook Dim ws As Worksheet, SrcRed_ws As...

Is there a way to perform a index match function if 2 conditions are met. I am able to get the correct results if I use the below function alone =INDEX(sheet2!C2:C2318, MATCH(1,(sheet2!A2:A2318=sheet1!X567)*(sheet2!B2:B2318="Replay"),0)) But I need to execute this function only if sheet1...

I need help in linking images when I enter SKU no in a quotation format. I have two sheets, one is a base file in which SKU no is in B2:B4000 and their corresponding images in E2:E4000 (images are inserted into the cell by copy-paste from PPT/PDF/websites- No URL available). Another sheet is the...

Hello! I am trying to find a formula where, using a static book size (say $1550000) and dollars over goal (say 250000) it will return the % at which commission is applied & can then calculate the annual bonus. For the example this would be 4% as the book size is between $1.5m and $2m, and the...

Hello There, Reference to the attached sheet, what is the best formula that I can use in Dashboard tab in Cell AL30 to check in Extract tab if there are figures for that specific month and to return it for specific segment, for instance in AP30 in Dashboard tab, it returns the Occupancy for...

I have a data table say A1:N100 Column A is Category Column B is Sub Category Columns C:N would be Jan - Dec I need a dynamic sum that only sums up if Category A value is "Criteria1", Category B value is "Criteria2" and for only the month of my choosing. Sometimes this will be current month...