VLookups

Hi Naaz

Thanks for getting in touch.

The best way to mask #N/A errors from the VLOOKUP is to nest it in an IFERROR function. IFERROR looks like this:

=IFERROR(formula, error message)

So your VLOOKUP formula could be modified like this:

=IFERROR(VLOOKUP(A1,B1:C6,2,FALSE),0)

You will need to modify the contents of your VLOOKUP to match yours. The 0 on the end is what is displayed instead of the #N/A error. Alternatives could include: "" would show a blank cell; "Error" for a more obvious error message.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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