Posts by Washerz

    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