Common errors encountered in MS-Excel and how can these be rectified
Not Applicable Error ( #N/A ): Reason: This error occurs when a function cannot find what it has been asked to look into the Source Data Table or Table Array. This means that no details exist into the data in reference to that selected lookup value. For Instance : Assume, we have applied Vlookup function in Table2 to find the Cost (Per Day) from Table1 in reference to lookup value as Resource Names, however this error occurred at the last cell because there are no details, for the resource 'A'. Solution: Make sure that the Source Data Table or Table Array is complete before its use into the function. If still (with the complete table), no lookup value exists in the table then either remain this error as it is or override this error into text as 'Not Applicable' move forward with the next calculation. For Instance : Assume , earlier we were working with the incomplete data in following Table1 and then after getting the complete data in which d...