match

I'm working on a table that references another and returns the number of employees in each of several regions, by year. The source table includes a row for each employee, with a value of '1' in the column for each year they worked: Destination Table: Year Region Employees 2020 a 1 2020 b...

Hi all - I've been searching for days for a solution and have yet to find one that works. Doesn't necessarily need to be VBA, but I think it has to be as formula's don't seem to work. I have 2 sheets "Split Request" and "Hidden". Split Request has account numbers in cells E9:E47. These are...

Hi, Looking for some advice on what could cause the variable exclude_yes_no to always be "Error 2015", doesn't seem to matter what is contained in the lookup value and lookup array cell(s). Thanks in advance! For info above this code I have code which sets current_selected_row_title_exc...

I cannot seem to write a vlookup formula that provides what I need. I am looking to search Products in A8-11 and return price in B8-11. I need to match A2 AND B2 in this search. As you can see, partial results should show for A8 and return the corresponding price in cell B8. Can you help...

Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...

Hello! This sounds so basic, but I swear I've searched for a long time and can't find exactly what I need. I have a list of (usually thousands of) contacts with multiple columns (E.g., let's simplify to: first name, last name, personal email, work email, phone) that I need to clean against...

If Column A in spreadsheet 1 matches column A in spreadsheet 2, then column C in worksheet 1 equals result from Column B in spreadsheet 2. What’s this formula need to look like? Cannot figure it out. Column A in both sheets have skus. I need to match these up. Then, I need the item...

Given three variables (starting row, ending row, and substring) return the full string of the first cell found in the given range that contains the substring. What formula can I use in D7 to return the string found within the given rows? Looking to be able to change the rows as needed. For...

I am trying to find the first empty cell in a row using FIND or MATCH, preferably MATCH. Below are the various ways I have attempted to write the code. in most of the examples I have tried either "" or " " to search. Also with using Find I have tried the search direction of xlprevious and...

Hi, if I want to use Offset but want to do this based on a value , so I want the cell reference containing X as my starting point, I have tried ; CELL("address",INDEX($A$1:$A$13,MATCH(D1,$A$1:$A$13,0),1) )[ = $A$4 Which returns the correct cell reference but when I nest in Offset I get...

Please help me with my workbook as Iam novice to Excel. I have 2 sheets, "STOCKS" and "ORDERLIST" .....I want to automate in Allocation Column the email address of the client matching the criteria of Product_Name,Size and Gender. its should return the email address as unique value, is drop down...

I have ~50,000 usernames in Column A on Sheet1. Many of those usernames repeat. On Sheet2, I have the same usernames in Column A, followed by their employee IDs in Column B. But on Sheet2, there are no repeats. I want to copy over the IDs from Sheet2 into the corresponding place in Sheet1...

Hi all, I want to search within range A1:B16 the CODE for each NUM in D1 to D8 with one condition. There are some CODEs that are of the form XXXXZZ and XXXX24 that belongs to the same "group". The CODE that ends with 2 numbers is the "MAIN" CODE within than group. The "MAIN" CODES begins...

Hi all, i am new to Excel and would like to know what is the code for VBA for this to happen. I would need to match the reference list to master list, Condition 1: IF column A matches Column C then paste Column C on Column E Condition 2: IF column B matches 50% or 60% of Column D (text) then...

I have two workbooks (both with tens of thousands of rows). Customer_bu_breakdown and Master. My "customer_bu_breakdown" summary sheet contains the information I want to match up. Column A is a customer ID column (which is the same as column F in my sheet1 worksheet). Column B on the...

Hey all, Thanks for taking the time to review my question. I must be missing something simple but for whatever reason I am missing something. In "Tab A" I have a list of "A" names, "B" dates and "C" total hours, In "Tab B" I have "A9:A39" each date of the selected month, "A1" the name I want to...

Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...

Hi everyone hopefully you can help me out with this as my head if fried. I have had a look at some of the other answers for similar questions but I can't see how they would work for my problem. I have a long list of parts in my inventory. I also have a list of boxes for storing the parts. I...

Hello, I'm still struggeling to figure out the match function and how it works. Sometimes it works just fine and does what I want, other times it just spits out errors without me understanding why. I'm puzzeled as of why this results in an error: (Run-time error '13': Type mismatch) Sub...

I have searched through many sites looking for what seems to me to be a very simple answer but nothing seems to work. This is a bogus workbook that somewhat matches a confidential workbook, thus the fictitious amounts. In column B you see text from a legend that indicates a specific activity. In...