Importing, but only certain information

  • Thread starter Thread starter Sweetie
  • Start date Start date
S

Sweetie

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
 
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???
 
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.
 
Back
Top