Dear All,
I am currently using INDIRECT formula in my excel sheet, which make all other excel workbook slow.
To replace INDIRECT i need your help to understand how the color name in "Allocation V1.xlsx'!GRAY" can alone be changed dynamically based on the value in another cell. Say for example if the cell value is RED then i need to refer "Allocation V1.xlsx'!RED"
Basically i will use "PAN India Allocation ver1.xlsx'!GRAY" inside SUMIFS formula.
Kindly help. Thank You
Regards
Krish
Bookmarks