# Get instant live expert help on I need help with excel vba iserror

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Hello. I am having issues with the ISERROR function
Solved by B. A. in 16 mins
Why does 2013 & 2016 not resolve VBA match. This statement works in 2007 (where I started my code) but always results in 1 for 2013 & 2016. MyHoliday = -1 * IsError((Application.Match(Cells(3, J).Value, Range("HolidayNotEaster").Value, 0))) Naturally HolidayNotEaster is a list of dates and Cells(3, J) is also a date
Solved by Z. W. in 30 mins
=IF(ISERROR(VLOOKUP(B9,\$M\$2:\$M\$10000, 1, FALSE)),FALSE,TRUE )
Solved by A. H. in 14 mins
=IF(ISERROR(CI48/CI5),"-",(CI48/CI5)) what is this formula calculating? is it making CI48/CI5 negative?
Solved by A. J. in 26 mins
I want to compare 2 columns with this formula = IF (ISERROR (MATCH (A1, \$ C \$ 1: \$ C \$ 5.0)), "", A1)
Solved by G. J. in 21 mins