HELP with Conditional VLOOKUP

Greetings everyone!

I have a manual task that I need to do every week in excel and I believe it is possible to solve it through VBA, but I have 0 knowledge about it.

Every Friday I have to update the columns "Previsto" and "Realizado" with the percentage of several initiatives in a table (around 200).

Is it possible to create a macro that, depending on the date column that is selected, I click on a button and it makes a VLOOKUP of the Previsto and Realizado values?

I'm suggesting the VLOOKUP function, but I don't know if it would be the best option. I believe that a conditional will also be necessary.

Any thoughts? : pray2:

Attachment 26710

Probably the best way to start this is record a macro of what you are doing.