How do I fix my IFERROR(INDEX) formula to pull data from a single sheet?

Options

I'm trying to pull publishing locations from a column in a sheet using Project ID. The first part of the formula and last part of the formula seem to be okay, I get the "Edit" option if I click on them, but the MATCH portion is giving me the "reference another sheet" message.

Here is my formula:

=IFERROR(INDEX{CE&T ARCHIVE Publishing Locations}, (MATCH([Project ID]@row,{CE&T ARCHIVE Project ID}, 0))

I followed the formula that I used before but this one only references one sheet instead of two, so I lopped off the second portion. I'm not sure where I've gone wrong. I'm trying to match the Associated Project ID in the current sheet with the project ID from another sheet so I can pull in the matching Posting locations column data.

Can anyone help me figure out what I'm doing wrong? Thanks very much! 🤔

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!