Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 or |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DGET/DSUM etc
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DGET/DSUM etc
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 he 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 or -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using DGET | Excel Discussion (Misc queries) | |||
dget or dsum criteria | Excel Worksheet Functions | |||
IF,DGET ? WHAT DO I USE | Excel Discussion (Misc queries) | |||
dget or dsum? that is the question | Excel Discussion (Misc queries) | |||
dget or dsum? that is the question | Excel Discussion (Misc queries) |