@DGET function

Reply #6

KnuckleHead — Wed, 29 Apr 2009 01:15:16 GMT

Thanks phileight,

I use an older version of Lotus123. It works great. I just need to figure out how to write formulas better. The program is loaded with lots of help, I really need to have a better understanding of everything it can do. I've written some macros and recorded some very simple scripts, but now I want to go further and create scripts. That's where I get lost quick. I don't comprenhend computer language, so it's taking me a lot longer to figure things out. I've been reading a lot... [ More ]

Reply #5

phileight — Tue, 28 Apr 2009 00:59:42 GMT

I can not make the DGET command work in excel per your example. I have checked many places that explain how things work, they all seem to be copies of the original. I think there is a small detail missing somewhere or this command is no longer supported maybe??? I am using 2007 version.

good luck

p8

Reply #4

KnuckleHead — Mon, 27 Apr 2009 03:09:54 GMT

I searched thru 1000 different rows (patterns) and did not discover another of the same pattern. What I did discover was that my pattern numbers are 1 number above the drawn number, so I'll just enter the pattern number as 1 number above the drawn number. Less automation, but it should work.

Thanks for the help.

Reply #3

Curious2k3 — Fri, 24 Apr 2009 18:54:35 GMT

Hmm. I do know that DGET will return errors if multiple matches are found. You may need to look into an array, using Index and Match.

Reply #2

KnuckleHead — Fri, 24 Apr 2009 13:36:56 GMT

Curious2k3,

Thanks, tried that, didn't work. It appears to be something to do with telling the formula to match these 3 cells for the other 3 cells. I haven't figured out how the tell the formula to match . I'll keep trying though.

Reply #1

Curious2k3 — Thu, 23 Apr 2009 15:22:35 GMT

It may be a problem for not defining where it needs to place it. Perhaps try the following.

=DGet(A1:D1, Ball One , A1:A2) and so on. Try defining the name.

@DGET function

KnuckleHead — Thu, 23 Apr 2009 14:02:59 GMT

Good morning all,

I am having a problem getting this to work.

Iwant to be able to enter winning numbers into my sheet, then have the@DGET formula in the cell next to the numbers get the pattern numberfrom a table on another sheet. Below is what I have that's not working.

@DGET($DATA= NUM1 #and# NUM2 #and# NUM3 , INDEX ,$CRIT= NUM1 #AND# NUM2 #AND# NUM3 )

This Range is named CRIT . [This is the sheet that I enter winning numbers into.]

INDEX Num1 Num2 Num3

ERR 5 6 7... [ More ]