+ Reply to Thread
Results 1 to 9 of 9

Vlookup Help

  1. #1
    Registered User
    Join Date
    11-22-2012
    Location
    United States
    MS-Off Ver
    Office 2013
    Posts
    25

    Vlookup Help

    Hi,

    I know this is pretty basic, but I'm having some trouble.

    Sheet 1
    Account number Business Type
    0001 Grocer
    0002 Clothing
    0003 Electronics

    Sheet 2
    Account Number Business Type
    0001 x
    0001
    0002
    0003
    0003
    0001

    So I want a formula that inserts the Business type value into the sheet 2 column depending on the account number and corresponding value in sheet 1.

    Thanks!

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Vlookup Help

    Try

    -VLOOKUP(A2,Sheet1!A:B,2,False)

  3. #3
    Registered User
    Join Date
    11-22-2012
    Location
    United States
    MS-Off Ver
    Office 2013
    Posts
    25

    Re: Vlookup Help

    Thank you,

    For the col_index_number, I assigned it to sheet 1 column 2. As that serves as the output value I want, correct?

    I tried that and got a #REF! response.

  4. #4
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Vlookup Help

    No, you use 2 as I showed.

  5. #5
    Registered User
    Join Date
    11-22-2012
    Location
    United States
    MS-Off Ver
    Office 2013
    Posts
    25

    Re: Vlookup Help

    Specifically:

    -VLOOKUP(A2,Sheet1!A:B,Sheet1!2,False)

    and this didn't work

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: Vlookup Help

    change the - to =
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Vlookup Help

    Quote Originally Posted by domnisignis18 View Post
    Specifically:

    -VLOOKUP(A2,Sheet1!A:B,Sheet1!2,False)

    and this didn't work
    Sorry, didn't see I had put that.

  8. #8
    Registered User
    Join Date
    11-22-2012
    Location
    United States
    MS-Off Ver
    Office 2013
    Posts
    25

    Re: Vlookup Help

    Of course, that's not the issue. Thanks for pointing that out though.

    What I have is =VLOOKUP(A4, 'Membership Application'!A:BA, 2, FALSE)

    and that output is #N/A but I know that that can't be right.

  9. #9
    Registered User
    Join Date
    10-26-2011
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Vlookup Help

    Trying making sure what you are looking up is the same as the table you are looking up. The second part is the range (or named range), of the table in Sheet1. The third part is the column you want to see. In this case, it is column 2.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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