How to extract information?

[EduPAz]

Hi,
Can someone please help me with this doubt?

I have in worksheet1 these columns:
Product: A, B,C
Code: 11111, 22222, 33333
Jan-19: 2, , 3
Feb-19:
Mar-19:1,8,9
...
Dec-19:5, ,


In worksheet2, I have the same product and code information. I would like to get the last moth where it was a quantity assigned for each product. For example:

Product:A
Code: 11111
Jan-19:4
Feb-19:
Mar-193
Apr-19:
May-19: 2
Jun-19
Jul-19
Aug-19:
Sep-19:
Oct-19:1
Nov-19:
Dec-19

In worksheet2:
Product: A
Code:11111
Last month: Oct-19

Thanks,

Edu

 

[synergy16]

i think a simple VLOOKUP would be perfect for this.....something like =VLOOKUP($A$2,Sheet1!$A$2:$D$4,4,FALSE) theres other ways to do it but that would work. if you want it in VBA script i could write it for you