matching columns

  1. Y

    Mirror(reconcile) Data on excel in same sheet

    Hello Team, i need to reconcile two sets of data and match them side by side on same sheet , the data are on different sheet Is there any macro to facilitate this tasks instead of using formulaes (lookup) Sheet 1 Sheet 2 The common data are in the column D in ''sheet 1'' and Column E in...
  2. J

    Match Data and Input Value

    Hello all! I'm working on a workbook where I need to match data and if the match is found, input a value. The workbook has two sheets - Sheet1 and VideoTracking. Here's what I'm trying to accomplish... Find an email match - match column F (VideoTracking) to column F (Sheet1[Provider Email ])...
  3. A

    comparing 2 excel columns and filtering duplicates

    Hi, I have two sets of data, one is a column with a certain set of numbers, lets say 11111 33333 55555 Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this: 11111 abc 22222 def 33333 ghi...
  4. D

    Missing Columns

    I am working on some vlookups from a Pivot table that has five results on them; however some of the results are null, so the column disappears. I have been able to link it to the grand total, which is what I want, just not to sure how I can get it to link on the columns. This is my statement...
  5. N

    VBA - Copying part of a row to matching column headers

    I have code to copy rows of data to another sheet if the cell in column L equals "High" or "Extreme". I'm unsure how to copy only certain columns of that row to the new spreadsheet, which has matching headers in place. I'd like to either copy columns 2, 3, 6, 12, 14, 18, and 21, or have the code...
  6. S

    Advanced exact partial match VLOOKUP help

    Hey Everyone I really hope someone can help me with this! I am doing a VLOOKUP match-up between company names in one column, and company names in another column. The company names have an inconsistent format (like HeroSwap, Inc. in one column and HeroSwap Incorporated in the other). I've...
  7. R

    Having a problem matching columns

    I used a few split text functions, (aka: right, left, find) and split the text into what I finally wanted. Now I want the new column of text to equal another column and only some of the text is matching up. For example, it kind of looks like this: First Column Split Column...
  8. M

    Trying to match product sku from 2 spreadsheets and if they match can I have the product id pulled from one to the other?

    Hey Everyone, this is my very first thread here please excuse any novice actions I may make while posting this, thanks. I have about a dozen spreadsheets (we'll call these the "Dirty Dozen") that all have product Sku's in column A and have a column for Product ID's in column B but no actual...
  9. A

    Two similar Excel sheets comparison and data filling

    Dear friends, I have 2 system generated Excel files that have certain combinations and prices against those combinations. The 2 Excel worksheets are based in the following format: Column A - Unique system generated ID, these IDs are different in both the sheets. Column B - Pricing Parameter...
  10. R

    Matching Two Columns with a twist

    I have 3 columns two cloumns are ACCT numbers and third is comments Column A has a longer list of acct numbers than does B, But column B had the same amount of rows as does C,(I copied and pasted from another sheet) How can i match A to B while still keeping C intact to B? Column A...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back