Query Formula Help!

I am currently creating a search query that will allow anyone to search for a name and get the corresponding information. For some reason, when I try these different formulas, I am receiving the error message even if the name is correct. I've included my references in the formula as well. Can anyone help with this?

Current formulas I'm using getting an error when correct name is entered:

=IFERROR(INDEX({Data Sheet ID}, MATCH(Name@row, {Suppliers Range 8}, 1)), "Enter correct spelling and full name")


=IFERROR(INDEX({Suppliers Range 2 ID}, MATCH(Name@row, {Suppliers Range 2}, 1)), "Enter correct spelling and full name")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!