Error handling in Excel - Basic techniques

[@philipboakes2974]

Your method of teaching is excellent. Delivered with clarity and at just the right pace. Keep up the good work.

[@MrSpreadSheet]

Great to hear!

[@debbiebent230]

I didn’t get a response I didn’t get my link

[@MrSpreadSheet]

Sorry to hear that, but as yet we have not heard from you in this respect ? :-)

[@gavinm894]

That's a really long winded way of dealing with the errors. You could just change the formula in your AA6 column to match this: =if(E6="","",VLOOKUP(E6, AnalysisTable, 2, FALSE)) Then copy that down the rest of the AA column.

[@MrSpreadSheet]

Thank you for your valuable insights. as you know there are so many ways to achieve nearly everything in Excel, this method highlights and addresses both the problem and the solution in step by step 'manageable' chunks. :-)