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!