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
Related:
- Vlookup
- If iserror vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Excel 2007 Using vlookup function in VBA ✓ - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
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