PDA

View Full Version : HELP with Conditional VLOOKUP



gdps
05-20-2020, 06:43 PM
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:

26710

paulked
05-20-2020, 06:59 PM
Probably the best way to start this is record a macro of what you are doing.