match

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

I have an Excel Workbook that has 2 sheets. The first sheet, is of my Job Details, and the sheet is named 'GBR Job Details' On this sheet, in Column A, is the Job Names, Column T, is the total number of tasks for the job, and Column W, is the Remaining tasks for the job. The second sheet, is...

Hi, I am looking to obtain an overall itemised count from a delivery taken from the scanned barcodes. The first image is the full inventory catalogue at where the items are looked up against. ABCDEFGH1ItemPart numberTests Per Kit ( tests x cartridge )2Amylase reagent4T8520640 (160x4)The full...

Hello, I'm having troubles searching through an array. I'm either getting a Mismatch or "unable to get the match property of..." error no matter what I try. I'm I deeply misunderstanding something? I'm trying to check if a value (string) appears further down the data-set, and if so print the...

i have a table of 6 column first 3 tables already have data in it in a certain sort i would like to keep second 3 table which i will put data in i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1 let...

Hi Everyone, This has been stumping me for about a week now and I need assistance. My work's scheduling program produces a horrible table to track schedules and I am trying to take the information it outputs and create a printable schedule from it. I have been able to do it for most of the...

Hi all, I'm trying to get a formula to do exact and partial matches. I use INDEX(...MATCH(...)) to look for exact matches and if fails, then I try to do partial matches using VLOOKUP() but is not showing expected output. The partial match should show the "best match", this is select the...