I want to copy information on a spreadsheet to another sheet by using ID numbers

[excel is cool]

Hello all! I have learned a lot today here in the excel forum! I forget how much Love excel until I have to try and create something for work.

I have attached a copy sheet for an example. Example....

John Doe
3 scot st
Ali, PA, 15001

SSN 123-45-6789
DOB 10/22/1987

John has a unique client ID(as all clients do) Using the client ID, I want the form to fill out John Does info as it shows. THe sreadsheet will show all info on 1 line... ID, First Last Address address1 City State Zip DOB SSN These are the headers and below it will show in one row all in its own cells and show as such... 12345 John Doe 123 main st anywhere FL 32901 12-1-1989 123-45-6789

By using the ID, I want all the information for that ID to populate in the cells the info is set up to receive. Can this be done, I believe so as anything seems possible with excel! Please open attachment for better understanding.

Thanks again for all the help!

Rob

[ChemistB]

Since you said "Using the Client ID", I put the client ID in A12 (made a dropdown using Data Validation).
Then you use a combination of VLOOKUPs to pull the individual data

For example, A13 (John Doe) is
=IF($A$12,VLOOKUP($A$12,$B$3:$K$9,5,FALSE) &" "& VLOOKUP($A$12, $B$3:$K$9,4,FALSE),"")
See attachment

[excel is cool]

Thank you. Now, how do I get the drop down to understand that if i type an id in that space it will do the same thing. I have over 35,000 clients to search would be painful. I want to be able to type in the ID and it will do the same as you just showed? Thanks again! That was awesome!

[ChemistB]

You don't need the dropdown. As long as your formulas refer to your entire range, you can leave A12 as a normal cell and type into it at your leisure.
The formula would be the same with a much bigger lookup range

=IF($A$12,VLOOKUP($A$12,$B$3:$K$35000,5,FALSE) &" "& VLOOKUP($A$12, $B$3:$K$35000,4,FALSE),"")