Look up, match then copy from 6 colmns

[raehippychick]

Hi again!

I've been having a lot of fun adapting a formula given to me on here that will look up, match and copy one cell across, but now I need to do the same with 6 cells in a row

Basically I have a worksheet called Europe which needs to stay the same and also have the data split into countries and rather than copying and pasting I'd love to have the data hop in all by itself!

So in the France tab I would like to have some formula(e) that look at the Europe tab and if there any reports that begin with FF the corresponding data from columns A:F inclusive will feed into columns A:F on the France tab

Hope I have explained it okay, attached is a simplified workbook with the relevant columns, rows and some dummy data

Many, many thanks in advance