Results 1 to 3 of 3

Vlookup Mixed

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    16

    Vlookup Mixed

    I am at a loss what to do here... I have tried many things

    Vlookup is very confused

    It gets the first match (it must convert to numeric)
    the second item very confused.

    SKU Lookup Item Number
    001 001
    001-12VDC #N/A
    001-24VAC #N/A
    001-24VDC #N/A
    001C #N/A
    001C-12VDC #N/A
    001C-24VAC #N/A
    001C-24VDC #N/A
    001CRS #N/A
    001CRS-12VDC #N/A

    I am getting a #NA value

    =VLOOKUP(A3,Database!A:B,1,FALSE)

    Any help our guidance would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup errors with mixed text & numerals
    By capt_tony in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2013, 07:31 AM
  2. Using a vlookup return cell with mixed elements in a subsequent calculation
    By jonesyhouse in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-10-2012, 07:45 AM
  3. [SOLVED] Vlookup mixed with IF, looking at a date.
    By galvinpaddy in forum Excel General
    Replies: 16
    Last Post: 06-28-2012, 07:05 AM
  4. Keyword search within a single cell mixed with vlookup
    By ndube50 in forum Excel General
    Replies: 3
    Last Post: 11-16-2010, 12:42 PM
  5. I mixed , help me in VLOOKUP()
    By 3Dmajid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2008, 06:40 PM

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