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 -----Original Message----- From: Wade Smart [mailto:[email protected]] Sent: Thursday, August 27, 2009 10:52 AM To: [email protected] Subject: Re: [users] Help with a VLookUp 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] Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security Policy apply --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
