I am trying to set up a file that is user friendly. One sheet will be the
sheet to key and the other sheet will be password protected with valueable
information that will need to be inputed into another system electronically.
I would like for the user to be able to key in one number and the other
information flood in. How can I set up a v look up to accomplish this? (I
was using a seperate sheet to have the table of information but can't seem to
get it to work). I can't use the if statement because I have about 20-30
items that need to be used... Any ideas? I'm a visual person...
Example:
User keys in:
Account Number 123456
Output (All in different cells and on another sheet)
(A1)Customer Name: ABC Sales
(B1)Address: 123 Main
Etc....
--
rojobrown
Bookmarks