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
Hello Sir,

In Sheet1 I Have Numbers Like
A-----------------B------------
4050
6080
9060

And In Sheet 2 I Have Data Like:

A------------------------B-------------------C-------------------D
Naeem - 4050--------18-May-95-------25-May-2010----XYZ
Karim - 6080----------20-May-95-------26-May-2010---ZYX
Salman - 9060

Now i want the formula in sheet 1 in B

I want vlookup formula like

if A1 Of Sheet1 is equals to A1's right 4 value of sheet2 then show b1 of sheet2 in sheet1.


i m trying this but not getting answer
=vlookup(A1,Sheet2!(Right(Sheet2!A1:D1,4)),2,0

Thanks In Advance.

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
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
0
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
Thanks Alot :)

Done :)

Regards,
GameStartNow
0