No announcement yet.

DGet vs Vlookup

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    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
    Last edited by Wigi; May 17th, 2006, 02:50.


    Excel MVP 2011-2014

    For more Excel memes: visit ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --


    • #3

      Re: DGet vs Vlookup

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