Query Formula Help!

mwhite24

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")

and

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

Paul Newcome

What error do you get when you remove the IFERROR piece?

mwhite24

Im receiving UNPARSEABLE and if I remove the Enter correct spelling etc, I receive INVALID REF

Paul Newcome

INVALID REF means your cross sheet reference wasn't created properly. Try following the steps in the below article to reference another sheet and see if that helps.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

mwhite24

Well the issue is that my formula is not set up the correct way. I'm following another formula someone posted to the community for their sheet that worked, but as I'm trying to replicate it, I'm receiving the error message instead of the corresponding ID number. I am wondering why I am receiving the error message that's in the formula "Enter correct name..etc" instead of the correct ID number. I'm not sure what the problem is with the formulas I've entered in the original post above.

Paul Newcome

Can you provide a screenshot of the formula open in the sheet as if you are about to open it?