index & match

Greetings - I have tried varations of INDEX and MATCH and various LOOKUPS, but I do not seem to be able to find the correct syntax to solve my problem. Any help would be greatly appreciated, thank you! I have 10 columns. In row CL1, if there is any data, the data starts in CL1 and cells to...

Seven groups of numbers are being compared. Based on the total points, I would like to determine the three most optimal group configurations (optimal meaning the highest and most equal values). These three groups will have the highest point value, but with the restriction that there are only 12...

Happy thanksgiving and Columbus day! Not sure if I'm thinking about this in the right way or if this is even efficient. I'm facing a couple of problems and can't construct the right formula. I feel it has to do with index, match, offset? I'm thinking about this problem in this way as I know...

The names of the products on the picture is NOT our products. I've made a look alike theme, with made up names, picturing the question I'd like help with. I need to purchase tons of flavours/month in order to keep production afloat, amongst many other products. The flavours are a big aspect to...

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...