Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing specific data into an Excel workbook
I would like to import data about one specific person from one Excel
'database' workbook into another workbook. One workbook should contain a "database" containing the names, DOBs, phone numbers, addresses etc. of several persons. In another workbook I would then like to be able to lookup and import all information about one specific person (for example defined by that person's DOB or phone number) from the "database" workbook into specific cells of the "new" workbook. Is this feasible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing specific data into an Excel workbook
You can use multiple VLOOKUP formulas for that
could look like =VLOOKUP($A2,[Workbook_with_database.xls]Sheet1!$A$2:$J$500,COLUMNS($A:B),0) assuming the table is A2:J500, A2 would be the impute cell where you would type the lookup value then you can copy the formula across as many rows as needed and it will pull the different values from each column in the table you might want to add an if function if A2 is empty =IF(A2="","",VLOOKUP($A2,[Workbook_with_database.xls]Sheet1!$A$2:$J$500,COLUMNS($A:B),0)) you can also use =IF(A2="","",VLOOKUP($A2,[Workbook_with_database.xls]Sheet1!$A$2:$J$500,2,0)) for the first lookup =IF(A2="","",VLOOKUP($A2,[Workbook_with_database.xls]Sheet1!$A$2:$J$500,3,0)) for the second and so on, the COLUMNS part will do that automatically if you copy across the first formula "kare9" wrote in message ... I would like to import data about one specific person from one Excel 'database' workbook into another workbook. One workbook should contain a "database" containing the names, DOBs, phone numbers, addresses etc. of several persons. In another workbook I would then like to be able to lookup and import all information about one specific person (for example defined by that person's DOB or phone number) from the "database" workbook into specific cells of the "new" workbook. Is this feasible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loosing data from excel file in shared workbook | Excel Discussion (Misc queries) | |||
Importing data for CSV into Excel using VBA | Excel Discussion (Misc queries) | |||
Excel references change when importing data | Excel Discussion (Misc queries) | |||
Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) |