Offset / Match / MAtch

  • Thread starter Thread starter Michel Khennafi
  • Start date Start date
M

Michel Khennafi

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
 
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offset/Match Double Lookup 4
INDEX - MATCH - OFFSET By Reference 2
arguments in MATCH and OFFSET functions 1
Displaying winner/first four placings. 5
Double Match - version 2 5
OFFSET problem 4
Can't get array formula to work in MATCH function 5
Lookup 2nd & last match with two conditions 6

Back
Top