I've read the entire thread and not seen this solution which is my favorite:
="HOME: "&VLOOKUP(10,$Sheet2.A2:B8,2,0)
--
Jim
--On Wednesday, August 26, 2009 02:12:46 PM -0500 Wade Smart
<w...@wadesmart.com> 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
--
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org