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

Colleen Jones

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! 🤔

heyjay

Missing parenthesis …

=IFERROR(INDEX({CE&T…

Colleen Jones

Thanks, I've added in the missing brackets, but that doesn't seem to help. I still have something wrong.

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

Ryan Sides

@Colleen Jones try this one…

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

Colleen Jones

Thanks Ryan, that didn't work for me either.

Colleen Jones

Now I've tried this: =IFERROR(INDEX({CE&T ARCHIVE Publishing Locations}, MATCH([Associated Project ID]@row, {CE&T ARCHIVE Project ID}, 0)))

I get" Incorrect Argument Set" so that's something new!

Colleen Jones

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

As far as I can see, it's telling me that the MATCH portion is where the problem lies. Not sure how to fix it as it's highlighting the first cell in the correct column.

Colleen Jones

Is the fact that the "Associated Project ID" column is the Primary column be what's causing the formula not to work?

Colleen Jones

@Ryan_Sides, not sure why, but I just tried your formula and changed the MATCH to Associated Project ID, and that worked!

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