Vlookup
Solved/Closed
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Mar 6, 2011 at 12:27 PM
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Mar 7, 2011 at 10:20 AM
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Mar 7, 2011 at 10:20 AM
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 7, 2011 at 01:28 AM
Mar 7, 2011 at 01:28 AM
not clear . what do you want in B1 in sheet1 .
do you want the date 18 May 95
in B1 in sheet 1 type this formula
=VLOOKUP("*"&A1,Sheet2!$A$1:$D$100,2,FALSE)
the star sign with &A1 gives wildcard
do you want the date 18 May 95
in B1 in sheet 1 type this formula
=VLOOKUP("*"&A1,Sheet2!$A$1:$D$100,2,FALSE)
the star sign with &A1 gives wildcard
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Mar 7, 2011 at 10:20 AM
Mar 7, 2011 at 10:20 AM
Thanks Alot :)
Done :)
Regards,
GameStartNow
Done :)
Regards,
GameStartNow