molsansk Wrote:

The first one, =INDEX(C1:C10,MATCH(1,(A1:A10=H1)*(B1:B10=H2),0)),
returns
#VALUE, but when I bring up the function dialog box, it shows the the
correct
value in the formula result but won't display it in the cell. Any clue
why?



This formula needs to be "array entered" as specified. To do this
select cell with formula, hit F2 then whilst holding down CTRL+SHIFT
keys hit ENTER.

Some people prefer to avoid these type of formulas for obvious reasons
which is why I also suggested the other approach, although, as I say,
they can give different results in some circumstances.....


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=574220