You build a VLOOKUP and it gives an #N/A (can't find it) but you then use the FIND tool and you find what you were looking for! A common problem in Excel. So why is Vlookup not finding a value that is there.
If you work with lots of data you will come across cases where you need something to happen if a cell is blank, or the opposite i.e. if not blank then calculate in Excel. Perhaps if the Excel cell is blank the formula must result in a zero, or only cells that are not blank should be calculated.
Due to the existence of various software systems, you often need to get numbers to match each others signs. You will therefore need to know the Excel formula to change negative to positive (and vica versa) in spreadsheets.
With the recent announcement of VAT in South Africa changing from 14% to 15% on the 1st April 2018, it is important that you start looking at the new prices you will be charging. To help we have created a simple South Africa VAT Calculator