Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing information from BCN | Excel Discussion (Misc queries) | |||
Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
Importing information from 2 workbooks into a 3rd one | Excel Worksheet Functions | |||
Importing information from 2 workbooks into a 3rd one | Excel Discussion (Misc queries) | |||
Importing relative positoin information | Excel Worksheet Functions |