Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: DGet vs Vlookup

  1. #1
    Join Date
    17th May 2006
    Madrid, Spain

    DGet vs Vlookup


    I'm new to the forum although I'm a great fan of the news letter. Reading thro' it I learnt that using DGet instead of VLookup will speed up my spread sheets. The question is how to use DGet.
    I have 2 big tables. In Table 1 I have the Customers details; for every register I have a unique Customer number. In the other, Table 2, I have only the Customer number and the VLookup formula fills in some of the data that is in Table 1.
    Can I accomplish the same task with DGet?

    Thanks in advance.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    15th August 2005
    Mechelen, Belgium

    Re: DGet vs Vlookup

    Hi Ricardo

    Let me first welcome you to OzGrid!

    I don't think it's a good strategy to follow. See also the attachment with an example. If you have many customers, you will have to replicate the criteria each time. Given the unique customer number, functions like VLOKKUP, MATCH, INDEX etc. will be far better IMO.

    For another example, have a look at this link.

    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by Wigi; May 17th, 2006 at 03:50.

    Excel Video Tutorials / Excel Dashboards Reports

  3. #3
    Join Date
    17th May 2006
    Madrid, Spain

    Re: DGet vs Vlookup

    Thank you Wigi. Now it's clear to me.

    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 6
    Last Post: July 19th, 2007, 01:44
  2. Vlookup Based On Results From A Vlookup
    By pzarate in forum EXCEL HELP
    Replies: 1
    Last Post: June 9th, 2007, 04:49
    By vik in forum EXCEL HELP
    Replies: 8
    Last Post: February 9th, 2005, 01:44
  4. Replies: 5
    Last Post: October 23rd, 2003, 10:32
  5. Help with VLOOKUP
    By spnz in forum EXCEL HELP
    Replies: 3
    Last Post: May 9th, 2003, 03:33


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts