Index Match Match?

[hansjhamm]

This one just seems to stump me!
What I have in the cell is:

=INDEX(Sheet1!C2:C1000,MATCH(D104,Sheet1!A2:A1000,0),MATCH(Sheet3!E104,Sheet1!B2:B1000,0))

and it gives me the eternal #REF!

What am I JUST NOT GETTING?


Thanks

Hans

 

[Bob Phillips]

Shouldn't the range

Sheet1!C2:C1000

span mutiple columns as well?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[RagDyer]

Try this *array* formula:

=INDEX(Sheet1!C2:C1000,MATCH(1,(D104=Sheet1!A2:A1000)*(Sheet3!E104=Sheet1!B2:B1000),0))

 

[hansjhamm]

Thanks Guys....Got it working!!

Hans

Try this *array* formula:

=INDEX(Sheet1!C2:C1000,MATCH(1,(D104=Sheet1!A2:A1000)*(Sheet3!E104=Sheet1!B2:B1000),0))

--
Array formulas must be entered with CSE, <Ctrl> <Shift > <Enter>, instead of
the regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

 

[RagDyeR]

Thanks for the feed-back.