Inputing information from one worksheet to another

[Coug4482]

In the last month, I feel I've gotten pretty good with Excel. But that's
only using one worksheet. I need to import Data from one worksheet to
another. Here's what I want to do. I want to go to one of the Cells on
Sheet 1 and type in a name, we'll say Jerry, for example. When I type in
Jerry, I want that to trigger all the cells in that row to input certain
information. Let's say the boxes are titled: last name, email, telephone #,
and office. On sheet 2 I already have everyone's info. Is there a way to do
this? I hope this isn't to confusing. Thanks for any help

 

[Mike H]

Hi,

In generally that's quite easy to do but without seening dour data layout
it's difficult to be too helpful but lets try,

Assume you type Jerry in A1 you could have this formula in B1, C1 etc

=IF(A1<>"",VLOOKUP(A1,Sheet2!A119,2,FALSE),"")
=IF(A1<>"",VLOOKUP(A1,Sheet2!A119,3,FALSE),"")

As soon as A1 has something in this will look at a table on Sheet 2 in the
cells A1 - D19 (you can change that). It will look for Jerry in column A of
that table and if it finds ot return the value from column 2 which would be a
piece of information relating to Jerry. Change the 2 to a 3 and you get
column 3 returned etc.

Mike

 

[Coug4482]

Mike, I hope you can give me a hand with this thing. Can I send you copy of
what I'm trying to do?

 

[Mike H]

You can upload a copy here

http://www.savefile.com/

and post the link

Mike

 

[Coug4482]

http://www.savefile.com/files/1505487

This is an example and a small piece, but the only part I'm having problems
with, now. I actrually have a few more cells, but I think if you can show me
how to do it, then I can modify it. Thanks

 

[Mike H]

Have a look at your file

http://www.savefile.com/files/1505548

Mike

 

[Coug4482]

Wow, thats awesome. Thanks. I appreciate it greatly

Brian

 

[Mike H]

You welcome and thanks for the feedback

Mike

Wow, thats awesome. Thanks. I appreciate it greatly

Brian