Problem with combination of Product, Offset, Address, Match

Hallo,

I would like to have the following calculated in ONE step. In two steps it works but when i combine it doesnt.

=ADDRESS(MATCH(B3;U1:U100);21;TRUE;1) returns the correct Cell Address ($U$52)

=PRODUCT(OFFSET(U52;0;2;10;1)) does its function correctly

however when I try to combine the 2 finctions above:

=PRODUCT(OFFSET(ADDRESS(MATCH(B3;U1:U100);21;TRUE;1);0;2;C3;1))

it returns a error!!

Can anyone help?

Many thanx!

Originally Posted by martindwilson

=product(offset(indirect(address(match(b3,u1:u100,0),21,1,1)),0,2,10,1))
change , to ; if needed
but
=product(OFFSET(U1,MATCH(B3,U1:U100,0)-1,2,10,1))
does the same thing

Worked like a charm! Many thanx!!!!!!