Consulting

Results 1 to 2 of 2

Thread: HELP with Conditional VLOOKUP

  1. #1
    VBAX Newbie
    Joined
    Jan 2020
    Posts
    2
    Location

    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?

    VBA VLOOKUP.xlsm

  2. #2
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Probably the best way to start this is record a macro of what you are doing.
    Semper in excretia sumus; solum profundum variat.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •