Forum Discussion
lot of VLOOKUP, IF, IFS made too slow.
a excel file, having 40 sheets, 400 rows in every sheet, containing at least 400 VLOOKUP, IF, IFS. this makes the file too slow while editing single record. any solution for the same.
My money goes to the VLOOKUP formulas. How many columns of VLOOKUP formulas do your sheets have?