I have values in two cells and would like to get actual difference figure in column ‘C’.
Column ‘A’ figure is from formula =IFERROR(VLOOKUP(C13,'Budget 2021-22'!$D:$N,11,FALSE), " ")
Column ‘B’ is also from formula =IFERROR(VLOOKUP(C6,'Apr 2022'!$B$3:I50,8,FALSE), " ").
If column ‘B’ is blank I am getting #VALUE! Error in column ‘C’. I would like to get blank cell in column ‘C’. Please help
Column ‘A’ figure is from formula =IFERROR(VLOOKUP(C13,'Budget 2021-22'!$D:$N,11,FALSE), " ")
Column ‘B’ is also from formula =IFERROR(VLOOKUP(C6,'Apr 2022'!$B$3:I50,8,FALSE), " ").
If column ‘B’ is blank I am getting #VALUE! Error in column ‘C’. I would like to get blank cell in column ‘C’. Please help