Vlookup

[imisy3d]

Sheet1, column-C2:C4 has the following values
359411083983706
452528741366222
521452282996963

Column-M2:M4 .....
INSTOCK
INSTOCK
INSTOCK

Sheet 2, column-C2:C3
359411083983706
521452282996963

Column-M2:M3
Sold on 28-04-2018
Sold on 02-05-2018


i want a formula to compare/match column-C of sheet1 with column-c of sheet2
if found/matched them sold on 28-04-2018 reflects on Column-M of sheet1, otherwise shows INSTOCK

please i need urgent help
thanks

 

[Jonmo1]

In Sheet1 M2 and filled down
=IFERROR(VLOOKUP(C2,Sheet2!C$2:M$3,11,0),"INSTOCK")

 

[imisy3d]

In Sheet1 M2 and filled down
=IFERROR(VLOOKUP(C2,Sheet2!C$2:M$3,11,0),"INSTOCK")

sorry, its not working, it showing all entries INSTOCK while 2 entries of C2:C4 are same

 

[Jonmo1]

Works for me.

Excel 2013/2016
	C	D	L	M
2	359411083983706			Sold on 28-04-2018
3	452528741366222			INSTOCK
4	521452282996963			Sold on 02-05-2018
Sheet1

Cell Formulas
Range	Formula
M2	=IFERROR(VLOOKUP(C2,Sheet2!C$2:M$3,11,0),"INSTOCK")
M3	=IFERROR(VLOOKUP(C3,Sheet2!C$2:M$3,11,0),"INSTOCK")
M4	=IFERROR(VLOOKUP(C4,Sheet2!C$2:M$3,11,0),"INSTOCK")

Excel 2013/2016
	C	D	L	M
2	359411083983706			Sold on 28-04-2018
3	521452282996963			Sold on 02-05-2018
Sheet2

 

[Jonmo1]

It's likely that you have mixed data.
of the 2 column C values, one set is real numbers, while the other is 'Numbers Stored As Text'.

Use ISNUMBER to figure out which is which.
=ISNUMBER(Sheet1!C2) - and fill down
=ISNUMBER(Sheet2!C2) - and fill down

 

[imisy3d]

sorry may be i am wrong, but its not working for me
=IFERROR(VLOOKUP(C2,SOLD05022018!C$2:M$3,11,0),"INSTOCK")
sheet2 name is Sold05022018
want to compare C$2:C$5
while M is 13 column instead of 11,

please help me
thanks

 

[imisy3d]

https://docs.google.com/spreadsheets/d/1oVOQ2fENewFDGlsIu1eXh6GJrgkTOVF5RewHP34wGq0/edit?usp=sharing

sheet2 and sheet 3 are in question
thanks

 

[imisy3d]

its the correct formula
=IFERROR(VLOOKUP(C2,SOLD05022018!C$2:M$3000,11,),"INSTOCK")

 

[Jonmo1]

its the correct formula

Is that a question, or a statement as in this is this now resolved?