+ Reply to Thread
Results 1 to 4 of 4

Lookup value in column A of range and return actual value of column c

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Limerick, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    28

    Lookup value in column A of range and return actual value of column c

    Hello all,

    I have a list of values in column A of workbook Joe.

    In workbook Bloggs, i have a portion of the values of column A workbook Joe in column A of workbook Bloggs. I now want to find where value in column A in workbook 1 matches a value column A of workbook bloggs return the value of column C.

    I was using vlookup(A2, bloggsA:C,3,0) but only got true or false, where the actual value in Bloggs C2 = Thanks, how can i get vlookup or alternative to return the actual value of C2

  2. #2
    Valued Forum Contributor kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    627

    Re: Lookup value in column A of range and return actual value of column c

    Quote Originally Posted by brian_2me View Post
    vlookup(A2, bloggsA:C,3,0)
    Is that you're "actual" formula?

    Replace the 0 with FALSE.

    bloggs looks incorrect and shouldn't work as it is.

  3. #3
    Registered User
    Join Date
    04-14-2014
    Location
    Kuwait
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Lookup value in column A of range and return actual value of column c

    you can send a sample of your excel to help us understand better what result you need

  4. #4
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    7,722

    Re: Lookup value in column A of range and return actual value of column c

    brian_2me,

    If you are not familiar with how to attach a file:

    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
    • be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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