Index Match False

[Nixonde1]

Hello, I'm using a formula found on the internet for a call center Shift bid. It looks it should work I get a #NA message when you execute the formula.

I'm getting a at #NA ISNUMBER(MATCH(B3:H3,I$2:I2,0)). The numbers in b2 represent a shift number.

The goal is to find the first choice out of the row and award it to the column "I' then as you down the list the false statement will not let you take a previous number that has already been selected. Any help?

	A	B	C	D	E	F	G	H	I
1	Name	Bid1	Bid2	Bid3	Bid4	Bid5	Bid6	Bid7	BID WIN
2	EMP 1	51	81	89	2	48	14	95	51
3	EMP 2	56	30	32	57	92	26	57	=INDEX(B3:H3,MATCH(FALSE,ISNUMBER(MATCH(B3:H3,I$2:I2,0)),0))
4	Emp 3	61	6	66	29	40	54	46	#NA
5	Emp 4	100	63	95	41	88	26	95	#NA
6	EMP 5	52	67	10	28	29	69	66	#NA
7	EMP 6	86	46	75	74	81	29	65	#NA
8	EMP7	4	52	29	17	59	78	88	#NA
9	EMP 8	32	62	80	17	85	11	94	#NA
10	EMP 9	56	3	54	75	70	83	38	#NA
11	EMP10	25	40	70	59	65	97	90	#NA

<tbody>
</tbody>

 

[admiral100]

Hi,

An array formula ....Ctrl+Shift+Enter NOT just Enter ....

 

[Nixonde1]

Thanks!