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
This Range is named "DATA". [It is my "Pattern" sheet.]
INDEX Num1 Num2 Num3
1 0 0 6
2 4 5 6
3 5 6 7
4 7 6 6
"ERR" is where the @DGET function is located and should be the answer 3.
I have setup the "pattern" table with "Labels" across the top and "General" throughout the remainder. Can anyone tell me why this formula will not work? I'm sure it has to be the way that I have the "=" (compare) written.
My spreadsheet program is Lotus123, although I understand that Lotus123 and Excel work very simular to each other.
I'd be greatful for any help and directions.