index match

These are two example sheets of what I am trying to do: Reference: Reference Sheet Summary: Summary Sheet I am trying to pull information from the Reference sheet into the Summary sheet. I want to pull based on the zip code I enter into the Summary sheet, cell B2, from the row matching that...

Dear..., I'm having some problem making the index match function to work properly. It does work for a few times, and then I get the message "unable to ge the index function of the worksheetfunction class. A B...

Hi all--Can anyone help me update the formula in cell I43 (sheet "Fac_1") so that it matches the value in Fac_1 B43 with the match in Column A on the other sheet, "Assume_xl2bb" for its corresponding month & year column? There are 20 years of projections, shown monthly, in both sheets. I...

I have a spreadsheet that I am trying to populate by using an array formula. Right now, I have a formula that looks in a range and identifies if the word "Spouse" is within it. However, I would like to update the formula to search for "Spouse" & "Ex-Spouse" within the same range, but my current...

Hello Everyone, I am working on a project using MS Excel 2021 data is organised as tables and stuck at these two problems as follow: 1. I need a setup the data validation will check the entered quantity in the "Qty" column of the "Invoice Detail" sheet against both the...

Hello, Hoping for some help. Unfortuanately the Xl2bb Addin is disabled on my computer by Admin access. I have 2 columns. Column A, contains the source data. This column contains a string of words. Column B will contain the formula. Column C contains a string of words. These values may or...

So, I have been tasked with a reconciliation project in which I have to reconcile the Financial Managers from Screenshot 2 to update the Managers from Screenshot 1, in order to add the corresponding fund category (shown in screenshot 1). The current list (Screenshot 1) will have additional funds...

New question for everyone, I'm trying to sum the prior month balance of all loan ID that are no longer in my current month as it was paid off. I can use this formula but adjust some values right? For some reason I get it to lookup all balances. =IF(Table2[@[Loan ID]]<>[@[Loan...

Hi Everyone, I'd like to turn an iferror index match formula for one column and a if(change(vlookup in my second column, into just one column. How would I go about do this? My formulas are: This works for finding out new loans by index matching the type to with the current Join concatenate...

I have three tabs in a file, one is a list of projects and looks something like this: Project Number Project Name 1234 Sales Software Development 4567 Marketing materials 7894 Furniture Purchase 8829 Sales Suite Fit Out on tab two I have an invoice log where i enter all the...

Hi I have following Table: A B C D E F Yr21 Yr22 Yr23 Yr24 yr21 £10,000 yr22 £8,000 yr23 £12,000 I am looking for following: A B C...

Hi, I am seeking help in a formula to show the results from evaluation that either shows if the consensus is either Exceptional, Satisfactory, Unsatisfactory or if it the outcome is a tied result based on the evaluation selection from other cells. Column "O" should show the consensus of "K-N"...

Hello, I'm new VBA and have been trying to covert a standard Index Match function to a User Defined Function in VBA to simplify the formula for users. (As I understand it, since the cell the function is in will change a UDF is required.) I have three functions I'm trying to figure out. I'm...

I have been racking my brain on this one and can't find what I'm looking for to line up names and positions from one sheet to another and to add to the difficulty if there were duplicates with the same time and position that the 2nd entry for that time and position would go onto the TRN line of...

First off thank you for the help! I have a daily schedule on Sheet1 and have the Employees entire year schedule on Sheet2. So what I have been trying to do is get the names from sheet2 on to Sheet1 by date and position. I have tried INDEX MATCH looking for the date then the positions to no...

I have a code that run the index match and vlookup function, but the problem is that the data I receive is not always the same (sometimes only 3 or 5). When I run the code, the code always ask me to update the value of the unavailable sheets. here's my code Sub Function() Dim ws As Worksheet...

Hello! I've got a question about an array index match formula that's partially working. So the set up of the data is on sheet2 I have the raw data being downloaded. On sheet1 I have a table with the formulas pulling back only the relevant information from the data dump. The table set up is...

Hi all! I have tried to find a solution to this problem, but so far nothing I've found has either worked or explained why it can't - so I'm turning to you guys! I have a standard data table from which I wish to display the maximum and minimum value of a given criteria using in-cell dropdowns...

I would like to count the number of 1s (on the left) and organize as shown on the right. notice rows 1 and 2 are hierarchical. in other words, something along the lines of "count soccer players in 2020 in Europe" My attempt was to first match headers then count the column returned by INDEX, but...

Is there a non-array Index Match formula that references field names instead of specific columns and allows for multiple search criteria? Here is my original post that solves the "reference field names" function: Index Match / lookup formula using column names Can I expand on this approach to...