index & match

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

Hi all I have 15 columns of data with 25 rows each. The columns are broken into sets of 3 therefore giving me 5 different groups. These are number 1 - 5, while my rows are numbered 5, 10, … 500, and my columns are labelled FWD, DB and RB Each group have the same columns but the values are...

Hello, I hope all is well. I don't know if we can use the index and match in this case. I tried, but I failed because I don't know how do I point the code to the name of the tab. I hope I could get some help on this one. Thank you in advance. Table I need to fill Date Total Hour Location...

PQRSTU2Cargo Horas metasPontos3Comandante de exercitoAspirante 8693533638154117603010Aspirante8693533638154117604Capitao tenente2Tenente 86935336381541176135202 Tenente8693533638154117615Major1Tenente 86935336382381671440301 Tenente8693533638238167146Capitao tenenteSoldado...