DGET/DSUM etc

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

broughton.ron@ic.gc.ca
or
ron_b@hotmail.com

ilia
Sun Mar 16 01:19:47 CDT 2008

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?

On Mar 15, 3:35=A0pm, ron_b <ro...@discussions.microsoft.com> wrote:
> Have a Lotus (remember that one) spreadsheet that uses lots of Dfunctions.=
=A0
> Converting it to Lotus and need help with the Excel function. =A0Here's th=
e
> Lotus function in my FTE worksheet:
> @DGET(MAP,"directorate",Activity=3DB6)
>
> In Lotus MAP is the name of the range in another worksheet. =A0That 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 t=
o
> look in
>
> Activity=3DB6. =A0Refers to the Acivity Col in my FTE worksht and those sa=
me
> activities are in the MAP range.
>
> In short.....go to the range named MAP. =A0Look 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. =A0I'm sure=
it
> syntax but its got me beat. =A0Can send the Lotus file if that would make =
it
> easier to understand.
>
> Thanks so much
>
> broughton....@ic.gc.ca
> or
> ro...@hotmail.com

Debra
Sun Mar 16 08:44:17 CDT 2008

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

ron_b wrote:
> 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
>
> broughton.ron@ic.gc.ca
> or
> ron_b@hotmail.com


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html