Vlookup and iferror formula question
I am writing a vlookup formula and I get a #NO MATCH Error. I want to remove the error and give a result of 0 which seems pretty straight forward.
The formula I wrote looks like this : =VLOOKUP(SO@row, {Machine File Oven A Range 1}, 9, false)
When I add the iferror formula it looks like this:
=IFERROR(=VLOOKUP(SO@row, {Machine File Oven A Range 1}, 9, false), 0)
The problem I am having is that now all of my results come through as 0 instead of the values that should be pulled. I am sure this is an easy fix, but I need some help. Am I writing the iferror formula in the wrong place? If anyone can help let me know.
Thanks!
Best Answer

Remove the equals sign from immediately before the VLOOKUP function.
Answers

Remove the equals sign from immediately before the VLOOKUP function.

Yes it worked! Thanks for the quick help, I should have asked much sooner.

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!