+ Reply to Thread
Results 1 to 2 of 2

Comparing 2 columns then updating and adjusting 2 other colums/updating

  1. #1
    Registered User
    Join Date
    08-14-2024
    Location
    United States
    MS-Off Ver
    Version 2308 Build 16.0.16731.20542) 32-bit
    Posts
    4

    Comparing 2 columns then updating and adjusting 2 other colums/updating

    Good morning,
    Rather desperate here. I've used very basic excel at my previous job but the new positions require alot more of an in-depth approach.

    General summary

    Comparing two columns for exact matches, column B and Column V.
    If any cell in column V exactly matches any cell in Column B (aside from blanks), then to take the 1-digit number assigned to column W on the corresponding match and transfer that data into column K with +1 value.

    TL;DR
    If any cell value in column B exactly matches anything cell value in V, then to take the digit assigned to W and transfer that number +1 to column K next to the cell number that matched.

    Really hoping there is a formula that can help me out.

    Not sure if I am saying this correctly so, please let me know if you need further information.

    Thank you in advance to anyone that can help me figure this out.
    Last edited by SteveC2024; 08-14-2024 at 01:48 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,182

    Re: Comparing 2 columns then updating and adjusting 2 other colums/updating

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

    Administrative Note:

    Is your forum profile showing the oldest Excel PRODUCT that you need this to work for?

    Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

    The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

    Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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. Help updating and comparing pricelist
    By dmanic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-15-2019, 11:52 AM
  2. Help updating and comparing pricelist
    By dmanic in forum Excel General
    Replies: 3
    Last Post: 05-14-2019, 04:24 PM
  3. [SOLVED] comparing 2 worksheets and updating one
    By kurtwm in forum Excel General
    Replies: 6
    Last Post: 03-14-2016, 07:39 PM
  4. Replies: 1
    Last Post: 05-14-2014, 08:24 AM
  5. [SOLVED] Comparing two columns and updating one
    By Vishlesh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2014, 07:14 AM
  6. Data comparing, copying and updating
    By Lars.Olson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 02:13 PM
  7. comparing columns across worksheets & updating
    By hifimono in forum Excel General
    Replies: 1
    Last Post: 09-24-2008, 12:59 PM

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