How about:

=INDEX($C4:$C9000,MATCH(1,($A$1=$A$4:$A$9000)*($A$ 2=$B$4:$B$9000),0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.

I'm retrieving the value from column C (instead of specifying a column in B:I)

And I'm looking for the first row that has a match in A4:A9000 to A1 and at the
same time a match in B4:B9000 to A2.

These portions:
($A$1=$A$4:$A$9000)
and
($A$2=$B$4:$B$9000)

Each return a bunch of true/false--depending on the match.

But when they're multiplied using:
($A$1=$A$4:$A$9000)*($A$2=$B$4:$B$9000)

That bunch of true/falses becomes a bunch of 1's and 0's.
(true*true = 1, false*anything = 0)



IP wrote:

I am using a formula and it has 2 or 3 different cells, it like as follow:
cell A1: January, A2:CH
now I want to take a formula to use those two cells as a combine like,
Index($B4:$I9000,Match(cell("contents",$A$2),$B$4: $B$9000,0),2) --this is my
original formula now I want to change and put down a two matching cells like
A1 and A2 in the formula... How can I do this?

--

Dave Peterson