Index and match on a colour coded spreadsheet

[aoife]

Hello,
I have a large spreadsheet, which I colour coded last month.
There is a new report issued each month and I want to be able to:

Index and match the work from the previous month (this bit I can do)
But I wondered is there a way to put the IF formula with Index to pull through the colour of the cells from the previous month?

Thanks in advance for any help you can offer

Aoife

 

[aoife]

I think It is something to do with IF(colorindexofrange

I have 8 different colours I need to pull through onto the new sheet

 

[aoife]

Pull through cell color when index and matching

I have got this far
=INDEX(last months,MATCH(thismonths,lastmonths,0),1)=CELL("CELLCOLOUR",'lastmonth column select)

Am I anywhere close
Please Help