Andy wrote:
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,
Your syntax is correct. The reference cell "G10" holds the search item,
which has to match an item in the "A" Column on sheet2. When this match
is found the item from the "B" column is returned to where the function
is called.
Example:
Sheet1, A1 = "HOME:".
Sheet1, B1 = VLOOKUP(G10;$sheet2.A2:B8,2,0).
Sheet1, G10 = number or text to search for.
Sheet2, A2 to A8 = some reference, numbers or text.
Sheet2, B2 to B8 = the team names.
Hope this helps.
So in sheet1, in A1 I want the team name, which is the vlookup, and that
part does work but, I want to add HOME in front of the name.
Instead of A1 = Brown Team
I want A1 = HOME: Brown Team
So any team that goes in A1 gets HOME put in from of it.
Of course in B1 (for example) I would have a different lookup do AWAY
Team Name.
Its adding in that static HOME: text.
I tried =concatenate("<<static text>>"; vlookup(G10;$Sheet2.A2:B8,2,0))
this that Pradeep posted but received another 508 error.
Wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
