+ Reply to Thread
Results 1 to 2 of 2

copy values from one excel sheet to another by matching multiple columns

  1. #1
    Registered User
    Join Date
    08-10-2022
    Location
    Maryland
    MS-Off Ver
    MS2013; MS365 (free); MS2017
    Posts
    1

    copy values from one excel sheet to another by matching multiple columns

    Hello,

    I now want to update a table based on 2 matching criteria in another table. I've been searching the web for help on using the index/match combination. The first example from one site in particular and the "non-array" example they use "seems" to be what I need, but I just get error messages. I thought the only problem was that I didn't have the same number of rows in one of the tables, but I did a test to at least "appear" to have the same row numbers but still got errors. Can someone help me fill the "chla" values from one table to the another as illustrated in the spreadsheet attached (screenshot of it below)?

    Thanks!
    IndexMatchChlaBottleExample2.png

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: copy values from one excel sheet to another by matching multiple columns

    This *should* work I think in D3:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] copy names and values of columns from multiple sheets to one sheet and subtract
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2020, 09:12 AM
  2. Replies: 1
    Last Post: 05-12-2020, 08:42 AM
  3. Copy matching values in range in two columns into another column
    By F1ash in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2019, 07:23 AM
  4. Replies: 8
    Last Post: 02-20-2018, 12:45 PM
  5. [SOLVED] Copy/Rename Multiple files using Excel values in columns
    By felizeng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2017, 10:52 AM
  6. vba matching columns of data and copy/pasting to new row on different sheet
    By maybefrog in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-27-2011, 07:36 PM
  7. Copy Variable Values to another sheet for Matching Values
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2009, 06:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1