How to have information auto fill between worksheets

Hello fellow nerds, I would like to know how to type in a persons name on one worksheet and have it automatically fill in information about that person that is saved on another worksheet

EX

Name Phone Available Info
Sam Smith 555-555-5555 Yes *^&%

Just by typing Sam i want all the info to auto fill from the other worksheet cell rows

is this possible?

I understand how to transfer cell information between sheets by using the =sheet1/b1 and =sheet2/b2 method, but I specifically want to type in the information in the cell, and have the following cells autofill with the information down the row.

Thanks in advance!


Rusty

You would normally use the VLOOKUP function to do this, but I can't give you a specific formula as you have not indicated where the data is located. It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button) as it doesn't work on this forum.

Hope this helps.

Pete