index & match

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

Hello all, I have a bit of a challenge here if anyone can help. I'm not entirely sure if it's even possible but I'm sure I've seen someone do something similar on a YouTube video but I may be mistaken. I want a formula (or formulas) in the range B8:O19, which will pull back information from...

1) The Values need to Match cell C1& B2 value like that cell value need to check. Condition like as below cells cell c1& b2 cell c2& b3 cell c3& b4 cell c4& b5 like this matching up to 100 After that I need total count of match value. The same way need to match reaming values...

Quick back story: I need to report shipping dates to customers. I gather this information by doing a two way index match on the customers PO number and the customers PO line number against our line number. When entering items into our system the Import Team is supposed create an order number...

I'm trying to create a lookup or match, where I would enter a State in a cell and of all the options from the original table, it would bring in the first 10 matches based on the state selected So this would be similar to a vlookup or match, but would need to pull more than the first results...

Hi all, im not sure the best way to get the following: I have 2 tabs with tables (like below) and im trying to get a formula in column DI that looks at table1, column BK and then BQ, BS & BU and if their is a match (e.g. MATH 100; MATH 105; MATH 107) to table2's column A&B then returns a "Match"...

Dear Excel-experts, I am trying write an Index & Match formula to output what kind of wooden box I need in order to ship different pipe variants to our costumers. The boxes has been designed to carry different pipe types with various dimensions. For now I am only interested in Type and Length...

Hi everyone. I hope y're all fine. I have a spreedsheet with prices for many products, according with the 4 criteria bellow: (1) City (2) Seller (3) Date (4) Product type Each product has a product "below" which price must be lower. So for example, the product B must be more...

Hi! I'm pretty comfortable with ifs and vlookup, but these formulas are not providing the results I am looking for. I am thinking I should use Index/Match, but I am less familiar with these and arrays. I want to match COLOR_1, NUM_1, START, END from TABLE_2 on TABLE_1, and return values for...

Hi, Please see the picture attached. For every number in the left column I am trying to match that number and the property type found in the row next to it and return the associated number at the top. So for example for 103 0 06 with property type house-Y i want it to return 0. Note that I want...

Hello, I have a spreadsheet that changes dynamically using the offset function. I want to be able to subtract in 1 column. I want to subtract the very last value in the last row by the first value. For example: In the image, please ignore column B. "Change in NFP", column C, is the column in...

Possibly a 2 condition index match formula? Data sheet is in a separate spreadsheet to the formula sheet. I am looking to return the relevant data (into cell G4, H4 & I4 on formula sheet) from the Data sheet (Task - column C, Frequency – Column B & Who – Column E) if the due date (column G on...

Hi, I have a table that has below format and need to update the amount from different table that has a different format, I tried using Xlookup and Index/Match but for some reason it didn't work. Could anyone help me? What I need to accomplish: - The template I have has 3 columns (Employee...

Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...