macro to do find multiple cells and replace

[jmkerzic]

I am looking for a macro to do lookup in column M, and and return the value that is in P. I was trying a Vlookup but it does not always find the the numbers in my sheet and I have tried to have the exact format for the columns etc. The spreadsheet is about 15,000 lines.

Basically looking in column O and if it is in Column M it would return the value in Column P to Column N.

Thanks.

I

 

[DanteAmor]

Check that the data does not have spaces to the right.

varios 10nov2021.xlsm
	A												M	N	O	P
1													UPC	New
2													192288355108	14	192288355170	10
3															192288355114	11
4															192288355183	12
5															192288355176	13
6															192288355108	14
7															192288360090	15
Hoja7

Cell Formulas
Range	Formula
N2	N2	=VLOOKUP(M2,O:P,2,0)