On Thursday 27 August 2009 00:42:46 Wade Smart wrote:
> Im needing to make a change on a document I have.
>
> =VLOOKUP(G10,$Sheet2.A2:B8,2,0)
>
> This gets the name of a sports team.
> The cells around this are filled otherwise I would just write in
> the text. But what I want is something like:
> "HOME" TEAM NAME
> Where "HOME" is static and TEAM NAME is from the function above.
>
> Wade
Wade,
I am not sure if I understand your requirement correctly. However,
would this help ?
=concatenate("<<static text>>"; vlookup(G10;$Sheet2.A2:B8,2,0))
You could use a cell reference to "<<static text>>" if you so want.
I hope this is of some assistance to you.
Pradeep Srinivas
Bangalore, India
--
on 26 Aug 2009, Wednesday, IST (which is GMT +05:30)
-----------------------------------------------------------------------
Adding manpower to a late software project makes it later.
-----------------------------------------------------------------------
Signature block is /auto/ /generated/ from the Unix utility *fortune*
fortune run at 20:50 IST on 26 Aug 2009, Wednesday
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
