VLookup Formula that can change Negative number to Positive and leave Positive

  • Hi Guys


    I am creating a Journal template for my team and i am using Vlookup to export data from a "Current Month Cost" spreadsheet to the upload journal. Would like to change negative numbers to positive in a VLookup formula and leave Positive as they are in my Journal.


    =VLOOKUP(D37,'Current month costs'!A:D,3,FALSE)*-1


    Above is my current formula, which is actually manual as I have to go cell by cell. Any help to implement the formula in the Vlookup would very much be appreciated.


    Regards


    Washington

  • Hello and Welcome to the Forum ... :smile:


    Have you tried the Abs() function ... =abs(insert_your_function) ...:wink:


    HTH

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!