Hello, i am pretty new to VBA however i need to solve an issue and some help would be greatly appreciated.

I have an excel spreadsheet with many columns however the key column is P which has dates in it and column J which has product in it. On another sheet i have a column (A) which has all the products listed and to the right i have columns with numbers for each corresponding month for each product. So column B contains January, column C has February and so on until April.

I need a comand that can look up the product name from column J and the date in column P and then find the corresponding product on the next sheet and month and transfer the number from that month back to sheet 1 to column Q.

I know this is a bit complicated but thank you in advance for the help.