+ Reply to Thread
Results 1 to 2 of 2

If Vlookup N/A, Input Box to Assign the look up cell to the data table

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    2

    If Vlookup N/A, Input Box to Assign the look up cell to the data table

    I export a list of codes that vary daily.
    I have a table in my excel document that has most of these codes & each are assigned one out of 4 categories.

    I copy and paste my exported codes into a worksheet.
    From there I start my macro: it uses vlookup formula to assign each code its category. [this is so I can autofilter later]
    However, because codes change/come and go, some codes are not in my table.
    When the vlookup comes back #n/a because the code isn't in my table, I want an input box to prompt the user.
    The user would then assign the code one of the 4 categories & press OK- this data would be transfered to the table & then allow the vlookup to return the category and continue down the list.


    Something like this possible? I know basic coding for vlookups and input boxes, just not sure how to get one on error down a list

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: If Vlookup N/A, Input Box to Assign the look up cell to the data table

    Something like this:

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ 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. Input Cell in One variable data table
    By Dottore Magistrale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 05:05 PM
  2. [SOLVED] Input Cell in One variable data table
    By Dottore Magistrale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. Input Cell in One variable data table
    By Dottore Magistrale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 08:05 AM
  4. Input Cell in One variable data table
    By Dottore Magistrale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. Input Cell in One variable data table
    By Dottore Magistrale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Input Cell in One variable data table
    By Dottore Magistrale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] Input cell on Data Table will not work
    By Sarah Bee in forum Excel General
    Replies: 4
    Last Post: 05-25-2005, 08:11 PM
  8. Assign a Macro to a Cell Input
    By tim4682 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2005, 11:45 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