Importing specific data into an Excel workbook

[Guest]

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?

 

[Peo Sjoblom]

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