vLookup/Match/Index

[ggovensky]

This should be very simple, however I can not seem to get this to work. Simply all I am trying to do, is type in a number and have several cells copy from another worksheet. Name,City,State,Zip,Phone. I would also like to input a first name and another vlookup/match or index pulls from another worksheet and auto fills out Name & phone number. I have notes in the workbook and would applicate if anyone can solve this for me.
thank you in advance.

To second this, I would want to send out only the 1st worksheet to a client and not loose any of the data that was auto filled in.