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?

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

 

[admiral100]

Hi,

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

 

[Nixonde1]

Thanks!