Pradeep Srinivas wrote:
On Thursday 27 August 2009 12:09:05 Ashish P Aghera wrote:
In mail by pradeep, there is syntax error for , instead of ;
correct shall be as below
=concatenate("<<static text>>"; vlookup(G10;$Sheet2.A2:B8;2;0))
Ashish Aghera
Ashish, indeed, you are right. Thank you for pointing this out to me,
and to Wade.
Wade : Please accept my apologies - I used "," in place of ";" (commas
in place of semi-colons).
Must be too much of Microsoft influence (grin)
Pradeep Srinivas
Darn MS influence :D
I changed it to ; and still have the ERROR 508.
=CONCATENATE("HOME:"; VLOOKUP(G10;$Sheet2.A2:B8;2;0))
Wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]