Offset / Match / MAtch
 

Good afternoon...

The following function

=+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$ C$10:$V$10,0))*$C$5

Is not supported by the reporting application i am using (Excelsius)...
Anyone know how I could transform this function to obtain the same result
and avoid the use of OFFSET?

Thanks so much

Offset / Match / MAtch
 

Hi Michael

Try
=INDEX($B$10:$V$161,B7,C2)*$C$5

--
Regards

Roger Govier


"Michel Khennafi" wrote in message
...
Good afternoon...

The following function

=+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$ C$10:$V$10,0))*$C$5

Is not supported by the reporting application i am using
(Excelsius)... Anyone know how I could transform this function to
obtain the same result and avoid the use of OFFSET?

Thanks so much

Offset / Match / MAtch
 

=INDEX($B$10:$V$161,MATCH(B7,$B$10:$B$161,0),MATCH (C2,$B$10:$V$10,0))*$C$5

have no idea if it will work in Excelsius though

also, there is no need to start a formula with a plus sign in Excel



--
Regards,

Peo Sjoblom

"Michel Khennafi" wrote in message
...
Good afternoon...

The following function

=+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$ C$10:$V$10,0))*$C$5

Is not supported by the reporting application i am using (Excelsius)...
Anyone know how I could transform this function to obtain the same result
and avoid the use of OFFSET?

Thanks so much