Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 90

Simple INDEX MATCH Question

Hi, I have what is probably a very simple question about an INDEX MATCH array
formula that I found on the Contextures website. In the following formula:
{=INDEX($D$2:$D$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$ 2:$C$7),0))}
what does the "1" after "MATCH(" indicate?

Thanks in advance for any information.

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 question.	Stan	Excel Worksheet Functions	6	August 3rd 07 02:22 PM
Simple (?) Match question	Steve	Excel Worksheet Functions	11	March 12th 07 05:22 PM
Index/match question.	Jules	Excel Discussion (Misc queries)	1	July 8th 06 04:03 PM
Index/match question.	Jules	Excel Worksheet Functions	0	July 6th 06 06:49 PM
Match + Index(?) Question	KemS	Excel Discussion (Misc queries)	2	March 31st 05 01:23 AM

All times are GMT +1. The time now is 10:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us