If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|