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.