Using two index/match formulas to sync data from 2 sheets to a master

Options

I'm trying to pull data from two different sheets into a master sheet using two index/match formula's within an iferror however it is only partially working with some pulling through correctly and others coming up as no match even though there is a match. In the example below KYP-RSK-002 should bring a review status of Due through to the master from the strategic risk register which is working correctly for KYP-RSK-0001.

Any help would be very welcome!

Here's the formula I'm using:

=IFERROR(INDEX({Strategic Risk Register Review Status}, MATCH([Risk ID]@row, {Strategic Risk Register Risk ID}, 0)), INDEX({Operational Risk Register Review Status}, MATCH([Risk ID]@row, {Operational Risk Register Risk ID}, 0)))

Columns in Master:

Columns in Strategic Risk Register:

Columns in Operational Risk Register:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!