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.
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
If not blank then calculate in Excel Mar 9, 2018
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.
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
South African Tax Spreadsheet Calculator 2018/ 2019 Feb 21, 2018
Free download of the South African Tax Spreadsheet Calculator 2018/ 2019 with salary versus dividends optimisation calculation.
Excel shuts down when opening a file Feb 20, 2018
If you have had the experience of Excel shutting down when opening a file you must know how frustrating it is. We experience it regularly, probably due to the size of the spreadsheets we build. However, it is sometimes even a small spreadsheet that perhaps contains a data table.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."