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*pm, 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


or