Vlookup
Solved/Closed
Game Start Now
Posts
138
Registration date
Thursday 21 January 2010
Status
Member
Last seen
8 May 2019
-
6 Mar 2011 à 12:27
Game Start Now Posts 138 Registration date Thursday 21 January 2010 Status Member Last seen 8 May 2019 - 7 Mar 2011 à 10:20
Game Start Now Posts 138 Registration date Thursday 21 January 2010 Status Member Last seen 8 May 2019 - 7 Mar 2011 à 10:20
Related:
- Vlookup
- Iserror function in excel with vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Copying Excel data from one sheet to another based upon contents of a cell - Excel Forum
- Vlookup if two cells match return value from third - Excel Forum
- Vlookup won't work ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
7 Mar 2011 à 01:28
7 Mar 2011 à 01:28
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 21 January 2010
Status
Member
Last seen
8 May 2019
7
7 Mar 2011 à 10:20
7 Mar 2011 à 10:20
Thanks Alot :)
Done :)
Regards,
GameStartNow
Done :)
Regards,
GameStartNow
