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.