Vlookup

[Solved/Closed]
Report
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
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 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Thanks Alot :)

Done :)

Regards,
GameStartNow