Index Match False

Nixonde1

New Member
Joined
Apr 27, 2011
Messages
4
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?

ABCDEFGHI
1NameBid1Bid2Bid3Bid4Bid5Bid6Bid7BID WIN
2EMP 1518189248149551
3EMP 256303257922657=INDEX(B3:H3,MATCH(FALSE,ISNUMBER(MATCH(B3:H3,I$2:I2,0)),0))
4Emp 36166629405446#NA
5Emp 4100639541882695#NA
6EMP 552671028296966#NA
7EMP 686467574812965#NA
8EMP74522917597888#NA
9EMP 832628017851194#NA
10EMP 95635475708338#NA
11EMP1025407059659790#NA

<tbody>
</tbody>
 

Forum statistics

Threads
1,085,843
Messages
5,386,297
Members
401,992
Latest member
CleverHopper

Some videos you may like

This Week's Hot Topics

Top