Discussion Locked

Lotus123 syntax of DGET

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

What is the breakdown of the following:
@DGET($DATA,D7,ACCOUNT=$A10#AND#ACCOUNT>""
I understand DATA is a worksheet name. It's the rest of the formula that has me puzzled.
Thanks in adavance.
James

2 replies

by oldjeep

James,
The on-line help in Lotus123 is beneficial for giving syntax and clues to a formulas. Per the Lotus help: "@DGET(input;field;[criteria]) retrieves a value or label from a field of a database table that meets specified criteria". This one isindeed puzzling since it's missing the close parenthesis, but maybe that was a misprint. But you're right, it is a puzzling formula.
Are you an EXCEL user primarily? There are a variery of differences between the two especially in understanding their terminologies.
You're right DATA is a "range-named" area of the spreadsheet or the Input area, D7 is a field , and the remaining are the criteria. The #AND# is a concatination function and the $ is an "absolute" making the A10 a fixed cell location.
Hope this helps you make it understandable, if not operational.
Good luck,
Jim (also a James)

This discussion is closed to new replies.