+ Reply to Thread
Results 1 to 4 of 4

Applying a VLOOKUP using an Alphanumeric Value search condition

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    New York, New York USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Applying a VLOOKUP using an Alphanumeric Value search condition

    Hi All,

    I've been testing a variety of different methods to force calculation of a VLOOKUP formula using an alphanumeric input:

    Sample scenario:

    G445="V11CH111PNPM"

    VLOOKUP(G445,Table Array,Column Index, FALSE)

    Does anyone have a failproof solution to this issue? I can't imagine this is an impossibility; any insight would be greatly appreciated. Thanks.

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

    Re: Applying a VLOOKUP using an Alphanumeric Value search condition

    Hi Jeff and welcome to the forum

    depending on the data you are searching for, if "V11CH111PNPM" is a cell entry in that range, it should work ok. However, by using terms like "table array" and "column index", you give me nothing to work on to see what might be happening.

    perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Applying a VLOOKUP using an Alphanumeric Value search condition

    it doesn't matter what the vlookup value is (ie number, text, alphanumeric, or formula value)

    the way a vlookup works is that it looks in the first column of the Table Array, so the value that you have (ie "V11CH111PNPM") must be in the first column of the Table Array

    I attached a workbook that explains how vlookups work
    Attached Files Attached Files

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,584

    Re: Applying a VLOOKUP using an Alphanumeric Value search condition

    What do you mean 'force' the caculation?

    VLOOKUP will work for numeric, alpha or alphanumeric data without problem as long as the data types match for the lookup value and the values in the lookup range.
    If posting code please use code tags, see here.

+ 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