match trouble

[red95]

=MATCH(2,1/(($A10:$A950=$A4)*($B10:$B948=$B4))) this works

=MATCH(2,1/(($A10:$A3000=$A4)*($B10:$B2998=$B4))) this does not

any help ? thank red95

 

[Anthony47]

$A10:$A3000=$A4
$B10:$B2998=$B4
The two ranges have two different sizes, wereas they need to contain the same elements.

Bye

 

[red95]

ok but
$A10:$A950=$A4
$B10:$B948=$B4


this works ?

 

[snoopyhr]

Silly question ,,,,, do you enter the second formula as an array ?

 

[red95]

=MATCH(2,1/(($A10:$A3000=$A4)*($B10:$B2998=$B4))) just like that soeey dont know alot about excel

 

[Marcelo Branco]

Hi,

What error message are you getting? Something like #VALUE?

Try entering the formula with Ctrl+Shift+Enter simultaneously
Select the cell
Hold down both Ctrl and Shift keys and hit Enter

Excel wraps the formula with curly-braces, like
{=MATCH(2,1/(($A10:$A3000=$A4)*($B10:$B2998=$B4)))}

M.

 

[red95]

thanks Marcelo that was it hope i may help you some time.

tahnks again red95

 

[Marcelo Branco]

thanks Marcelo that was it hope i may help you some time.

tahnks again red95

You are welcome and tks for the feedback

M.