Look up colour from another tab based on title match and show on another tab

[MattExcelLearner]

Hi all,

I'm looking to do an index match or lookup that basically needs to do the following.

1) I need the correct recorded RAG colour pulled into the Gannt chart tab into row J.
2) The correct colour comes from tab query (9) - this will be fully populated in time from an extract from SharePoint

Basically what I'm trying to work out to happen is, match the work package name from Gannt chart column C in tab query (9) to the work package name in there then see what colour is reported in column E and show in the Gannt chart column column J.

This means whenever query (9) tab data updates regarding RAG colour this will populate column J in the Gannt Chart view.

Hopefully that makes sense

Thanks

Is this impossible to?

Notes:

Tab: Query (10) the main part of the Gannt data comes from
Tab: Query (9) the reporting RAG colour comes from