Non of the look up is working sorry guys
thanks any way.
----- Original Message -----
From: "Wade Smart" <[email protected]>
To: <[email protected]>
Sent: Friday, August 28, 2009 2:28 PM
Subject: Re: [users] Help with a VLookUp
Andy wrote:
Wade Smart wrote:
Wade Smart wrote:
Pradeep Srinivas wrote:
Darn MS influence :D
I changed it to ; and still have the ERROR 508.
=CONCATENATE("HOME:"; VLOOKUP(G10;$Sheet2.A2:B8;2;0))
Try adding $sheet2 -----------------------------^ just before the B8.
I was able to get it to work with out the error.
This works:
=VLOOKUP(G10,$Sheet2.A2:B8,2,0)
None of these work:
=VLOOKUP(G10,$Shee2.A2:B8;2;0)
=VLOOKUP(G10,$Sheet2.A2:$Sheet2.B8;2;0)
=CONCATENATE("HOME "; VLOOKUP(G10,$Sheet2.A2:$Sheet2.B8;2;0))
=CONCATENATE("HOME: "; VLOOKUP(G10,$Sheet2.A2:B8,2,0))
=CONCATENATE("HOME: "; VLOOKUP(G10,$Sheet2.A2:$Sheet2.B8,2,0))
Im using verion 3.0.1 build 9379.
Wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
