ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Please Help me With DGET (https://www.excelbanter.com/excel-discussion-misc-queries/76323-please-help-me-dget.html)

uscx1

Please Help me With DGET
 

I'm familiar with how to use DGET, where I have a database setup, and I
can retrieve an entry based on matching parameters. However, I can
only get it to return one entry. How would I make it so DGET will
return every entry rather than#NUM! when there is more than 1 matching
entry?


--
uscx1
------------------------------------------------------------------------
uscx1's Profile: http://www.excelforum.com/member.php...o&userid=32324
View this thread: http://www.excelforum.com/showthread...hreadid=520816


Debra Dalgleish

Please Help me With DGET
 
Instead of DGET, you could use an Advanced Filter to return matching
records. There are instructions in Excel's Help, and he

http://www.contextures.com/xladvfilter01.html

uscx1 wrote:
I'm familiar with how to use DGET, where I have a database setup, and I
can retrieve an entry based on matching parameters. However, I can
only get it to return one entry. How would I make it so DGET will
return every entry rather than#NUM! when there is more than 1 matching
entry?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com