Thanks for you help, but i must be one of those really dim folks....;-)
There are so many choice out there on the help, im just not sure which one
is the correct one, i have tried a few things, but still no luck

Here is what i have.....

A master sheet, ID numbers, names and so on....
Blank sheet.... I want to be able to type a id number, and then excel to
import the name from the master.....
Any ideas???

"Ashish Mathur" wrote:

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