index & match

Hi I'm hoping someone can help me or tell me it's just not possible! I'm trying to create an automatic stock checker by entering a list from our system versus external location reports, once I've entered the data I can only seem to show if there is a match but not which item, status or where...

Hi everyone I have a set of data with different notification dates for several projects (some different projects have the same notification date) and different owners (table in A7 column, as a Source). My goal is to filter and list all the projects that fall within a certain date range (column...

Im really not sure how to explain this but here goes, Starting from the right, as u can see each item has specific range of KP (from column K and L). We start with item 1 for example, which range from 0.211 to 0.216. Now i would like to match these range to the ones in column A. Once that...

Hello- I have an excel workbook with two tabs. One data set including transactions with relevant data columns: Account Number & Amount. The second tab has a comprehensive export of data that I am trying to match with the first tab of data. The relevant data columns are included as well as a...

Hello! I have a range with columns "Product", "Type" and very many date columns, the one on the left in XL2bb. This shows the inventory for each day. Please note that in reality the products, type and dates are way more than in this example. I need to create a table (the one on the right in...

Hello excel experts, I want to grab a list of unit numbers based on criteria in another column. If a row in column G contains "Tax Credit", return the corresponding row value in column B. There is a formula that accomplishes this task: =INDEX(Sheet1!$B$8:$B$86,SMALL(IF("Tax...

Hi everyone I have a set of data with different notification dates for several projects (some different projects have the same notification date). My goal: filter and list all the projects that fall within a certain date range, in this case by month and year. In this example, I want to show...

Hi, I have 2 Sheets(workbooks in reality but I made the test sample in 2 sheets). DATA sheet: All text/numbers. No formulas in this sheet. RESULT sheet: CFGMNOP1IDItemBalanceMatch Failed (Accessorials)Invoice Rejected (Accessorials)Approval Failed (Accessorials)Amount Due233283896Stop-off...

I have 2 sheets Export (Contains a table) Sheet4 (Contains a range of data) on Export I have an ID ref number in column D. This ID refers to a person on Sheet4 with multiple job start dates back on the Export tab, I also have a shift date in column M ([@Shift_Date]) I want to look...

=INDEX(A:A,MATCH("9-"&U29,F:F)) I want the above formula to return a value from column "A" by matching "9-number" from F column. For example, U29 cell = 135. So 9-135 would be in F:F column and it would give me the data in A column. Please help. Thanks!

Hi there, I'm working on a self-scheduling sheet for a group of 30 employees and I'm trying to figure out how to match two criteria and it populate a single name (index:match type of function except you're matching for possibility of two). Example: Everyone signs up in column B for Mondays...

Hey people, I'm currently working on a sheet containing thousands of entries where I will need to update information that is repeated throughout many sheets. Rather than manually 'Search & Replace', I was wondering if there was a way without doing (=A2), to have a formula that will associate...

Dear Excel gurus: i have a sheet that looks like this: Department Period Hours Worked Alpha 1 324 Alpha 2 421 Alpha 3 221 Beta 1 331 Beta 2 89 Beta 3 111 Gamma 1 0 Gamma 2 12 Gamma 3 212 And what I'm trying to do is to have another sheet do a lookup on a Field List with...

I have a following table. Name Value X 10 Y 20 Z 30 X 40 Y 50 Z 60 X 10 Y 60 I wish to extract all the unique values corresponding to the name in separate columns. The output shall come out like this. Since X has 10 as a value twice, I want it to be considered only once...

Hello - looking for an Excel whizz. Trying to complete Cell J3 with a column header based on the player and their 'score' from the week. I have tried a combination of LOOKUP with INDEX MATCH but not quite getting it. Any help would be much appreciated. Many thanks!

Here is my current formula: AVERAGEIFS ( INDEX ( $H$10:$X$505, , MATCH ( [SKU], $H$10:$X$10, 0)), $E$10:$E$505, [City], $F$10:$F$505, [Store Name]) I am trying to summarize the average prices (H11-X505) by product (header cells H10-X10), city and store (Columns E-F) in a separate table using...

I'm an Excel 365 user, and a very new one at that. Forgive me for my lack of etiquette within this forum, I hope that this first post may help introduce me to a way to solve this specific problem of mine, as well as to learn more about Excel 365 in general, and how to properly interact with this...

I'm trying to setup a formula for products I produce and ship that will automatically pull the correct shipping price based on a defined set of criteria. I've been able to do this with Index after I heavily edit my shipping tables, but I was hoping someone could assist me with this when my...

I have two formulas that work perfectly but I want to add another if (I think) element to the formula. I have just got a small sample of data and based on the small sample its not worth trying to find a short cut but when you have 100 data sets and 500+ rows of data. So what I am wanting is on...

trying to make this index formula in vba ActiveCell.Formula = "=" & "@INDEX(oss,MATCH(A2,OSS!AJ:AJ,0),@COL)" where col is an integer variable. if I put a number its working fine, also checked the value in the debug and there is a number over there. yelp