openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Douglas Pitonyak <and...@pitonyak.org>
Subject Re: VLOOKUP vs Macros
Date Sun, 29 Sep 2013 18:04:52 GMT

=ADDRESS(1, 3, 1,, "sheet1")

returns

SHEET1.$C$1

=INDIRECT(ADDRESS(1, 3, 1,, "sheet1"))

returns whatever is stored in the cell referenced by SHEET1.$C$1

On 09/28/2013 11:30 AM, John Meyer wrote:
> I have a spreadsheet with a number of worksheets.  The first worksheet 
> has the bonuses for employees in this format
>
>
> ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N), 
> Bonus For Date (N). . .
>
>
> The rest of the spreadsheets are each named for the date of sales that 
> they contain.  They are in the same format as the column header for 
> Sales For Date.
>
>
> I set up each row like this
>
> ID static, Agent name static, 
> =COUNTIF(*staticdateworksheet*!ColumnWithIDFirstRow:ColumnWithIDNthRow,Firstcolumnrowiamin),BonusCalculation
>
>
> What I'd like to do is change that formula around to resolve the sheet 
> name by the first row of the salescount ID (i.e. if It's 9-27-2013 it 
> would pull up 9-27-2013, 9-28-2013, etc.).  Is this possible?  It's 
> not a pressing issue, I'd just like to see if it could be done.
>
> Thanks.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message