Excel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! Christine
Having trouble with IF formula
Hello, I'm not sure what's going on with my formula, but it is supposed to double the "Grip" when a checkbox is checked. All the numbers being pulled from tables are correct and when not checked the "Grip" adds up correctly. When doubled, it is also adding the "Wall Thk." number an extra time. Correct single Grip = 1.625" Correct double Grip = 3.25" I get 3.5" for double grip. Formula used below, as well as pictures. If my formula is wrong, then I can't see it, but it has to be adding T8 somehow. =IF(X8,((INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE,0))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF"))*2),(INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE, 0))))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF")
Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, AnupamHelp with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into another tab within the same workbook. The formula below works perfect but the only problem is it has to be only the word "discover" (yellow cells) in the cell, if it says "discover - food" (green cells) it doesn't pull. Is there a way to have the formula pull the data if the word "discover" shows in column C but with other words like in the green cells? My current formula that kinda works: =INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*('My ✓ing'!C:C="Discover"),0)) Pulling from this sheet below Into this sheet in the same workbook. The yellow ones work because it just has discover, the green is not cause it has Discover - food. Is there a way to get it to search for the word discover and not necessarily match? Thank you for any help!
Formula to Autofill Value Based on Another Cell
I solved part of this but not the second part. I have these three columns on a document I am working on. I need a formula to do two things: If Column I lists a frequency (Annual, Biannual, Triannual) then K will autofill the next review date based on the date in Column J. If Column I lists TBD, then Column K should also autofill with TBD. In this scenario, Column J will remain blank. The formula I have so far is =IFERROR(EDATE(J2,LOOKUP(I2,{"Annual","Biannual","Triannual"},{12,24,36})),"") (I'm using IFERROR to hide the #NA returns in the blank cells.) I can't figure out what formula to add in to return a value of TBD instead of a date if Column I is TBD.
ExcelAt40 – Day 11: Lookup Wars – VLOOKUP vs XLOOKUP
Hello Excel fam 👋 Today’s post dives into the differences between VLOOKUP and XLOOKUP — with a visual comparison, practical tips, and even a quiz to test your lookup knowledge. We also covered how to use XLOOKUP with IFERROR for cleaner formulas and wrapped it all up with a cheat sheet. Would love to hear: 👉 Are you still using VLOOKUP? 👉 What’s your favorite XLOOKUP trick? #ExcelTips #ExcelCommunity #LookupFunctions #OlufemiBuilds #ExcelAt40How to resolve formula discrepancy Excel/SharePoint
Good afternoon, could someone help me? The formula =IF(ISERROR(INDEX(Form1!F:F, ROW()-90)), "", IF(INDEX(Form1!F:F, ROW()-90) = "", "", INDEX(Form1!F:F, ROW()-90))) works in offline Excel, but in SharePoint/Excel Online it shows an error. It appears there is an error in the formula. I am using Portuguese in both versions.
