Hi,

You may want to use the VLOOKUP() function. it is well explained in Excel's
help menu

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sweetie" wrote in message
...
Hi Peeps,

I have what i would call a master list, has ID numbers and names. How do i
use a blank sheet, type in the ID number for example, and excel to
automatically import the rest of the infomation?
I know it can be done.........


"if i only had a brain"

Thanking you