Previous Topic Next Topic

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

Answer 1 / 2
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
Answer 2 / 2
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

Similar discussions

Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses