VLOOKUP? MATCH INDEX? Not sure which would work in this scenario, if any

[AFIOF719]

Trying to figure out how to get data from one tab to another. Not sure if its vlookup, match/index, a combination of both, some concatenates.... I just can figure it out

Basically trying to get columns R though X on the Revenue Tab into columns G though H on the Revenue (View2) tab using some kind of a formula. If additional rows or data needs to be added, please do so.

Any help greatly appreciated.

Thanks,

[Pete_UK]

Put this formula in G5:

=IF(COUNTA($A5:$F5)=0,"",IFERROR(INDEX(REVENUE!$R:$X,MATCH($C5,REVENUE!$B:$B,0)-3+MATCH(DATEVALUE("1"&G$3&$G$2),REVENUE!$A:$A,0),MATCH($D5,REVENUE!$R$4:$W$4,0)),""))

then copy across and down as required.

Hope this helps.

Pete