Russel has attended:
Excel Advanced - Formulas & Functions course
Hiding errors in large data samples
I often have to perform Vlookups on data which will return a lot of errors. In order to make the data look cleaner I use an 'Iferror' formula to return zeroes and then a conditional format to make those zeroes blank. It's a bit cumbersome and I'm sure there are better ways to do it.
I hope you can enlighten me!
Many thanks
RE: Hiding errors in large data samples
Hi Russel,
Thank you for the forum question.
The Iferror function is the best solution, but change 0 to "" then you will not need the conditional formatting.
It will also make your workbook working faster.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
