Posted to microsoft.public.excel.misc

[email protected] hansjhamm@yahoo.com is offline

external usenet poster

Posts: 47

Index Match Match?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index, Match and filters	Steve M	Excel Discussion (Misc queries)	4	August 22nd 06 09:12 PM
Match Index	cjjoo	Excel Worksheet Functions	3	October 25th 05 09:33 AM
Match or Index Question	carl	Excel Worksheet Functions	2	October 4th 05 09:11 PM
Match & Index	Phyllis B.	Excel Worksheet Functions	2	November 27th 04 03:26 PM
Vlookup, Index & Match	Phyllis	Excel Worksheet Functions	1	November 8th 04 06:11 PM

All times are GMT +1. The time now is 12:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us