is a DGET more efficient than a LOOKUP function? I'm currently using a VLOOKUP and it's just fine, but I thought a DGET may be quicker...but I could be totally wrong, so if you could clear that up, I'd appreciate it.
Yes, DGET would be faster but less flexible than e.g., VLOOKUP.
As far as my DGET, let's say I have 3 columns in my database with the following 3 rows:
{Name, Q1, Q2}
{Item1, 11, 22}
{Item2, 33, 44}
My formula: DGET(range,"Q1", ?? )...it works if the '??' is either a named range or a cell reference. The problem is that I don't want to have to have a 2 row criteria for each DGET, of which there are many. I'd like to use an array in the formula like {"Name";"Item2"}.
Alas, no constant arrays as {"Name";"Item2"} as criteria; Try:
DGET(range,"Q1", TRANSPOSE(E1:E2))
where E1 houses "Name" and E2 "Item2", it won't work.
Aladin
This message was edited by Aladin Akyurek on 2002-04-17 15:02
This message was edited by Aladin Akyurek on 2002-04-17 15:03