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]

Reply via email to