Getting error on index and offset

[rahulshewale1]

hiii,


Please find the attached screen shot .i am gettting error on index and offset





Thanks
Rahul shewale

 

[bosco_yip]

Maybe........

=INDEX(OFFSET(Sheet1!$B$1,MATCH('Web pro''data'!D$1,Sheet1!$B$1:$B$211,0),,MATCH("RV Number Total",OFFSET(Sheet1!$B$1,MATCH('Web pro''data'!D$1,Sheet1!$B$1:$B$211,0)-2,-1,,1):Sheet1!$A$246,0),10),E2,4)

Regards