At 20:49 17/07/2017 -0400, Emery E. St. Martin wrote:
VLOOKUP works properly when I use "Tools Options... Calculate [ ]
Enable regular expressions in formulas". If I change .. Calculate [
] .. to .. Calculate [tick] .. then my VLOOKUP function won't work properly.
Your probl
2015-05-04 8:12 GMT+02:00 imran patel :
> dear regina,
>
> I don't know how to use V-lookup in Open office. can you explain me the
> process of how to use it. if possible kindly also send me some images of it
> so it would be more & easily understood.
>
> imran
>
Or just press Ctrl+F2 and take it
There is good information online specially on our documentation but also
other youtube videos will give you step by step guide on how to use it.
https://forum.openoffice.org/en/forum/viewtopic.php?t=46746
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Using_formulas_to_f
dear regina,
I don't know how to use V-lookup in Open office. can you explain me the process
of how to use it. if possible kindly also send me some images of it so it would
be more & easily understood.
imran
-
To unsubscribe,
On Thu, 20 Feb 2014 00:23:17 -, Wade Smart wrote:
=VLOOKUP($E18,$Teams.$A$12:$I$23,($G$10+1),0)
E18 = Player Number on Roster (1 to 12)
Teams.A12:I23 = Team Roster names
G10+1= the input of team number
So we have Teams A 12 to 23
1
2
3 etc
Teams B
player name
player name
etc
Teams C
=VLOOKUP($E18,$Teams.$A$12:$I$23,($G$10+1),0)
E18 = Player Number on Roster (1 to 12)
Teams.A12:I23 = Team Roster names
G10+1= the input of team number
When this was setup we werent concerned with player
jersey numbers but since that time, we have had to
add them to all our forms.
What I would
Strike that last e-mail, it worked.
On 10/3/2013 11:57 AM, John Meyer wrote:
On 10/3/2013 11:42 AM, Brian Barker wrote:
At 10:59 03/10/2013 -0600, John Meyer wrote:
After looking over this problem a bit, I decided to scrap the sheet
name idea and just have all sales on one sheet.
sales are i
On 10/3/2013 11:42 AM, Brian Barker wrote:
At 10:59 03/10/2013 -0600, John Meyer wrote:
After looking over this problem a bit, I decided to scrap the sheet
name idea and just have all sales on one sheet.
sales are in this format:
DummyField, Date, DummyField, DummyField, SalesRep
For this tab
At 10:59 03/10/2013 -0600, John Meyer wrote:
After looking over this problem a bit, I decided to scrap the sheet
name idea and just have all sales on one sheet.
sales are in this format:
DummyField, Date, DummyField, DummyField, SalesRep
For this table, I want to get the number of sales genera
Thanks for the help.
After looking over this problem a bit, I decided to scrap the sheet name
idea and just have all sales on one sheet.
sales are in this format:
DummyField, Date, DummyField, DummyField, SalesRep
For this table, I want to get the number of sales generated for a
particular
At 08:47 03/10/2013 -0600, John Meyer wrote:
http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png
http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png
Here are the worksheet names and the formula I am using.
I haven't been following th
http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png
http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png
Here are the worksheet names and the formula I am using.
e working with a big formula and it doesn't work, hit Ctrl+F2
>>>>>> (select the cell that you are working with first) and you are able to
>>>>>> study
>>>>>> your formula a little better. For instance you can see sub values by
>>
Returns an Err:501.
On Sun, Sep 29, 2013 at 10:59 PM, Coreurus
wrote:
<
- Original Message --(Start-looking-by-there)
From: John Meyer >
To:
Sent: Saturday, 28 September, 2013 04:40 PM
Subject: Re: VLOOKUP vs Macros
I sent that a little too soon.
The title refers to
omething wrong here.
=COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
Returns an Err:501.
On Sun, Sep 29, 2013 at 10:59 PM, Coreurus
wrote:
<
- Original Message --(Start-looking-by-there)
From: John Meyer >
To:
Sent: Saturday, 28 September, 2013 04:40 PM
Sub
t;
> >> Johnny Rosenberg
> >>
> >>
> >> >
> >> >
> >> > On Mon, Sep 30, 2013 at 1:22 PM, John Meyer
> >> > wrote:
> >> >
> >> > > =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
> >> >
eyer
>> > wrote:
>> >
>> > > =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>> > >
>> > >
>> > > On Mon, Sep 30, 2013 at 1:18 PM, John Meyer <
>> > johnme...@pueblocomputing.com
>> > > > wrote:
>> > >
> > >>
> > >> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
> > >>
> > >> Returns an Err:501.
> > >>
> > >>
> > >>
> > >> On Sun, Sep 29, 2013 at 10:59 PM, Coreurus wrote:
>
>>
> >> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
> >>
> >> Returns an Err:501.
> >>
> >>
> >>
> >> On Sun, Sep 29, 2013 at 10:59 PM, Coreurus wrote:
> >>
> >>> <
> >>> - Original Me
,"Bonuses")).$E$1:$E2000,A2)
>>
>> Returns an Err:501.
>>
>>
>>
>> On Sun, Sep 29, 2013 at 10:59 PM, Coreurus wrote:
>>
>>> <
>>> - Original Message --(Start-looking-by-there)
>>> From: John Meyer >
>>>
>
>
>
> On Sun, Sep 29, 2013 at 10:59 PM, Coreurus wrote:
>
>> <
>> - Original Message --(Start-looking-by-there)
>> From: John Meyer >
>> To:
>> Sent: Saturday, 28 September, 2013 04:40 PM
>> Subject: Re: VLOOKUP vs Macros
>>
>&g
Thanks for that, I will be sure to try that out when I get back to the
office. I've heard the Indirect and address method mentioned before, but
didn't have a practical example of how to use it.
On Sun, Sep 29, 2013 at 12:04 PM, Andrew Douglas Pitonyak <
and...@pitonyak.org> wrote:
>
> =ADDRESS(
=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 emplo
cluttered solution would involve pulling the date
from the bonus calculation field and then doing either a VLOOKUP with a
count or Macro. Where would I start looking if I wanted to do either
one of those solutions?
Back to searching for the answer
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 contai
25 matches
Mail list logo