Offset / Match / MAtch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michel Khennafi - 04 Jun 2007 22:35 GMT

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

Reply to this Message

Roger Govier - 04 Jun 2007 22:50 GMT

Hi Michael

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

Signature

Regards

Roger Govier

> Good afternoon...
>
[quoted text clipped - 7 lines]
>
> Thanks so much

Reply to this Message

Peo Sjoblom - 04 Jun 2007 22:57 GMT

=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

Signature

Regards,

Peo Sjoblom

> Good afternoon...
>
[quoted text clipped - 7 lines]
>
> Thanks so much

Reply to this Message