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.
--
Andy Brown
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
