+ Reply to Thread
Results 1 to 3 of 3

how to lookup a value in column "A1",find a match in column R1:R34,then grab value in "Z"

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    13

    how to lookup a value in column "A1",find a match in column R1:R34,then grab value in "Z"

    Hi, I have attached an image for what I am looking for, along with a sample xls. Basically I have two sets of data where one set has extended information that I need to pull into the other to add more context. So, I need to compare what is in column a1 and find a match in a different column, and then take one of the bits of data from that row. Please see the picture as it may be harder to explain than show.

    Thanks for any help in sharing the formula to do this.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: how to lookup a value in column "A1",find a match in column R1:R34,then grab value in

    looks like a VLOOKUP.
    =VLOOKUP(A2,G:J,4,0)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    06-25-2008
    Posts
    13

    Re: how to lookup a value in column "A1",find a match in column R1:R34,then grab value in

    Thank you so much. That worked!

+ 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: 2
    Last Post: 07-24-2017, 02:19 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Find or lookup the 2nd 3th... "different" match in column
    By zeko90 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2015, 12:04 AM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. Replies: 0
    Last Post: 07-09-2009, 04:07 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