DGET/DSUM etc

[ron_b]

Have a Lotus (remember that one) spreadsheet that uses lots of Dfunctions.
Converting it to Lotus and need help with the Excel function. Here's the
Lotus function in my FTE worksheet:
@DGET(MAP,"directorate",Activity=B6)

In Lotus MAP is the name of the range in another worksheet. That wksht has
a column for Directorate (see next) and one for Activity

"directorate" is the name of the column in that range in MAP that I want to
look in

Activity=B6. Refers to the Acivity Col in my FTE worksht and those same
activities are in the MAP range.

In short.....go to the range named MAP. Look in the Column called
directorate and find the Activity that is specified in cell B6 of this
worksheet and put that directorate value in this cell in my FTE worksheet.

I've tried everything and I keep getting NAME or VALUE errors. I'm sure it
syntax but its got me beat. Can send the Lotus file if that would make it
easier to understand.

Thanks so much

(e-mail address removed)
or
(e-mail address removed)

 

[ilia]

Here's the hangup I'm seeing: "Look in the Column called directorate
and find the Activity"

What is "the Activity"? What does finding "the Activity" entail?

 

[Debra Dalgleish]

In Excel, you don't enter the criteria in the formula, you refer to a
range that contains a heading and the criteria. You'll find examples in
Excel's Help.

For your example, the heading would be Activity, and in the cell below
that, you'd enter the value that's in cell B6, or type =B6

The criteria range is similar to those used in Advance Filters, and
examples of that are shown here:

http://www.contextures.com/xladvfilter01.html