In my excel , i have 5 columns as in attached excel
I would like to update Col E in Sheet "Calculation" based on date in work sheet "Band Details". Formula to be used is
Match band in col D of Sheet "Calculation" with band in "Band details" sheet
multiple FTE Size in "Calculation" sheet by the corresponding Weightage and fill col E in Sheet "Calculation"
Bookmarks