you can use VLOOKUP()... =VLOOKUP($A2,Sheet1!A:R,2,0) would go into cell B2

change to
=VLOOKUP($A2,Sheet1!A:R,3,0) in C2 and so on.

Alternately, you can look at perhaps some VB code to keep your formulas from
taking up a huge amount of space. Unfortunately, I'm no good with writing
that kind of thing...

"Trev" wrote:

I have a workbook and on sheet 1 I have entered information in columns A thru
R. I am needing a formula that will populate sheet 2 when I enter an
identifying number. Example
Sheet 1
ID#, Address, Date, Phone, etc.
So when I enter the ID# on Sheet 2 all the info in column B thru R is
populated in sheet 2.
Thanks,