Invalid Value error using INDEX & MATCH

Steve Dearing

Hi

I copied a project PMO and reset the links from project metadata to the project input sheet for the new set. All the columns now return "INVALID VALUE". I changed some headings which match on both sheets, the formula shown was not changed.

Any help would be appreciated.

Steve

Paul Newcome

It doesn't look like you are referencing the correct cells for the first range. The first range should be the data you want to pull from. When pulling from a table like this, you should be referencing all of the columns that are covered by your "Header Row" range.

Paul Newcome

Are you able to provide a screenshot of the reference sheet as well?

Steve Dearing

Reference sheet below

Thanks

Paul Newcome

It doesn't look like you are referencing the correct cells for the first range. The first range should be the data you want to pull from. When pulling from a table like this, you should be referencing all of the columns that are covered by your "Header Row" range.

Steve Dearing

Perfect, thanks for the speedy response.

Didn't realize I had to highlight the columns to reference.

Paul Newcome

Happy to help. 👍️