Hi rojo,

If you can send me an example worksheet I will give it a go.

Regards,
Howard

"rojobrown" wrote in message
...
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