+ Reply to Thread
Results 1 to 5 of 5

Grabbing data from an adjacent column if data in first column matches a value?

  1. #1
    Registered User
    Join Date
    08-11-2017
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Question Grabbing data from an adjacent column if data in first column matches a value?

    The screenshot below is a sample set of data on a second worksheet of a XLS file. In the first sheet I want to create a formula that will return the result of column C's value if the value in column A equals 135 for example. The values in column A are always going to be the same for the template I create so those values always stay the same when I call them. It is the dollar amounts that change depending on how the report is ran so I need to be able to dynamically call what is in column C.

    The row number can change depending on the report date... which is why I am trying to grab the adjacent column data from where it finds the data in column A. Hope that makes sense.

    How would I write this?

    Screen Shot 2020-08-17 at 5.31.11 PM.png
    Last edited by jderosa3; 08-17-2020 at 05:38 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Grabbing data from an adjacent column if data in first column matches a value?

    Sounds like you need to use VLOOKUP. Something like
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-11-2017
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Red face Re: Grabbing data from an adjacent column if data in first column matches a value?

    So thankful for people like you. Very much appreciated. Worked like a charm.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Grabbing data from an adjacent column if data in first column matches a value?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Grabbing data from an adjacent column if data in first column matches a value?

    You're welcome.

+ 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. Replies: 4
    Last Post: 05-24-2020, 12:26 AM
  2. [SOLVED] Pulling data from a column based on if it matches data if another column
    By Aredeekay in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2019, 08:32 AM
  3. Replies: 2
    Last Post: 01-27-2015, 12:10 PM
  4. Summing a column where matches adjacent column and colating results
    By rlamb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 08:24 AM
  5. Replies: 5
    Last Post: 02-24-2012, 06:04 PM
  6. Hard? SUM the values of a column that matches a flag in an adjacent column
    By Nokao in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-07-2012, 11:29 AM
  7. Grabbing Data From Second Combo Box Column
    By DBAL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2005, 10:06 AM

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