Importing, but only certain information
 

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

Importing, but only certain information
 

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

Importing, but only certain information
 

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

Importing, but only certain information
 

Well, the "Vlookup" page in help would be the best one, that's why
Ashish suggested it.

On the blank sheet, type an ID number into A2. Then in B2 you would
put:
=VLOOKUP(A2,data_range,column_number,FALSE)

I would write down a better formula for you, but you need to give more
details, like what your data looks like. You need to know what your
"data_range" and "column_number" are.