Dear All,
I need help on the following issues :
OpenOffice.org Version 2.1 from the Help menu.
1. B17 contains text "Pbs" and Brokerage_??? are two
3x3 vlookup tables, cells D17 and E17
contains numbers, the product of which is looked up in
one of the two tables and a value
returned. Cell B17 will contain a text string of 3
letters.
First
2. =(IF(B17="Pbs";"Brokerage_Pbs";"Brokerage_Mlk"))
returns Brokerage_Pbs
and
3. =VLOOKUP(D17*E17;Brokerage_Pbs;3) returns 12
Then why does :
4.
=VLOOKUP(D17*E17;(IF(B17="Pbs";"Brokerage_Pbs";"Brokerage_Mlk"));3)
return Err:504 (error in parameter list)
Second
5. =CONCATENATE("Brokerage";"_";B17)
returns Brokerage_Pbs
But
6.
=VLOOKUP((D17*E17);CONCATENATE("Brokerage";"_";B17);3)
returns Err:504
Third
7. =(VLOOKUP((D17*E17);'Brokerage_Pbs';3))
returns Err:502 (Error : Invalid argument)
But
8. =(VLOOKUP((D17*E17);Brokerage_Pbs;3)) returns 12
Yet formula no. 7 has been working in older versions
of openoffice and also works in another
sheet.
In Writer, autocorrection is very helpful but in calc,
autocorrection should be turned off by default as the
automatic captilisation of first character, changing
the first character after the " ' " or ' " ', or
inserting single ticks unnecessarily.
Thank you for your help
regards
tirath
____________________________________________________________________________________
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for
today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
