index / match

I'm trying to do a formula where I'm looking up the rate in a particular column in a table based on an ID number (first column). Each ID number shows up twice in teh table (once with $ amounts and then second with a rate). How do I do a vlookup formula to show me what is in column 3 the second...

Hey everyone, I have struggling with this for days now...and my team is depending on me to figure this out soon. I need help with doing some sort of lookup on data that is in different columns below a merged header cell. I need a specific cell to be chosen based on the name that I input. For...

Background: All in the same workbook - different tabs. the formula will return on the 'Proforma' tab row 185 I want to use a number from the input tab in a specific cell - match that number in row 13 on the proforma tab in the same column that the match is found - put the number there from...

Hi there. Could someone kindly assist me with an XLOOKUP formula I'm using to pull in data from a master tab to another sheet? I want to pull in data onto "Store 1" sheet based on: Store Number month year line item name (revenue, COGS, etc.) =+XLOOKUP(1,('Data Master'!$B$7:$FZ$7='Store...

I have an invoice reconciliation workbook where the first sheet (Data) is a list of the Planned Amounts by Vendor and Project ID. All of the other sheets in the workbook are broken out and named by the Project ID. I'm trying to compare the Planned Amounts by Vendor on the Data sheet to the Total...

Hello everyone, I need a bit of help. I need some formula that will make me the following… if the text in the A column of "sheet1" is the same as the text anywhere in the A column of "sheet2", and also if the text in the B column of "sheet1" is the same as the text anywhere in the B column of...

Hi! I'm currently working on a project where I have to match a reference number to one number from a separate column that is within +/-3 of the reference or equal to the reference. What formula can I use to do this?

Due to security controls on my system, XL2BB is not an option. Sorry, I really would prefer using that to writing this all out. Below is the destination table (well, one of them) I'm using to capture employee hours per month per department. This department is "AC" and is one of the few that has...

I'm sure this will be easy for one of you. I'm close, need a final tweak. I have a table of kids names with batting order in column1 (B3:B16), Inning # in row1 (C2:H2) and position they are playing each inning (1B, 2B, SS, etc.) scattered throughout the table. I'd like to create a unique cell...

Having issues with my index match formula and i've even tried the filter function, but going back to what I thought I knew IndexMatch, its just pulling an answer and I have no idea why. Table IJKLMNOP5ManufacturerSizeDumpster costDecal CostDecal InstallExt CostTruckloadTotal Cost6Boxgang20 Std$...

I am making a meeting overview of an event. I create each meeting down the rows and mark an "x" under each participant and time of the meeting (both along the columns). Hereafter I would like to make separate cellar overview where it automatically marks "free", "booked" or "double-booked" for...

Hello I am trying to use VBA to get values from 1 worksheet into another with index match based on 2 criteria. The problem is that i need the script to return a value only when BOTH criteria find a match. My code appears to return a value even when only one of my criteria matches. My knowledge...

Hi guys! Not sure how to approach this - with lookup and aggregate, an index/match sub or something else. So In the sheet called Empty, when B2 is filled, it populates the Invoice column in D4:D with unique invoice numbers from an external order sheet. The Sales sheet has a list of orders where...

I'm trying to do a vlookup (or an index/match if those functions are better suited), to find values based on the matching date, as well as 2 headers on a single column, and then I need to sum the returned values. The challenge I'm running into, is that I need to pull the data that matches the...

Hi, I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15. Order ID Name Poule Number Victories Prop Indicator 845.3333333 James 1 5 0.83 12 497...

Hi! This wonderful forum helped me out a while back with a work project I just could not figure out. I am back again with a similar work project that is throwing me for a loop and was hoping you guys could help me learn where I am going wrong. I'm not understanding something about my...

Hello, I'm looking for a formula to return the most commonly occurring text in a range minus a specific phrase. Is there anything I can add somewhere into the formula I already have, which returns the most commonly occurring text? Or do I need to rewrite what I already have? Here's what I have...

Hi everyone, New to this forum so hopefully this is ok, and I explain it right. I'm trying to find a way to auto-generate invoice amounts by using the invoice number. Index Match works perfectly on one column, however the way the spreadsheet works, some new invoice numbers are on the same row...

Greetings, I have a set of IDs, stored in a 1D-Array A. The IDs are already sorted alphabetically and all of them are unique. Now, I want to find the index of said IDs in another array B, where the IDs are although sorted alphabetically, but many of them are duplicated (E.G. ID...

Hi, I am trying to index the column headers (B1:E1) when they match colour (I3:I8), and have a value greater than 0. I would like to match all valid results and not just the first too please. An example of the results I am after are in J3:J8. Any help greatly appreciated...