Dget Function getting #Num! Error

[webmax]

Dear Team,

I am try to put DGET Function with two workbook but showing #NUM! Error.

I have two excel sheets first is Data base and contains entire database. Second sheet name as Output.

When i put DGET Function for the first record the output is coming correct. But for the other records (After first record) it is showing # Num! Error
Attaching the two excel workbook and guide how to resolve this

Regards
Sham

 

[AlanSidman]

Look at this link for an explanation.

https://exceljet.net/excel-functions/excel-dget-function

The function is designed to only retrieve a single result.

 

[webmax]

OK for this what formula is suggested for these type of data.

 

[AlanSidman]

In B2 of Output, type =INDEX([Database.xlsx]Sheet1!$A$2:$A$6,MATCH(A2,[Database.xlsx]Sheet1!$B$2:$B$6,0)) and then copy down the column.

 

[bosco_yip]

In addition to AlanSidman's explanation of DGET function in Post #2

Database function like DGET won't retrieve information from a closed workbook.

INDEX/MATCH function will work just fine in external references to a closed workbook.

Regards
Bosco