• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dget Function getting #Num! Error

webmax

Member
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
 

Attachments

AlanSidman

Active Member
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

Excel Ninja
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
 
Top