Results 1 to 4 of 4

Using LOOKUP from user input in a single cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Using LOOKUP from user input in a single cell

    I need to create a PIN-protected digital signature. My idea is to have a cell where the user types in his PIN, and from a table on a linked worksheet containing a column of PINs and their respective names, LOOKUP finds his name and replaces the PIN number with his name. For aesthetic and security reasons, I'd like this to all happen in a single cell so that the PIN disappears when the user hits enter, to be replaced by his name.

    Any help appreciated!
    Last edited by Hambone70; 02-06-2011 at 01:36 PM.

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