I have a formula It appears to work in the builder, and when I reference other formula in it, all appears ok.. but when in the field nothing shows up..I removed the IFFERROR trap while testing it.. any idea what I missed




=INDEX(Car_Shop!$D$2:$D$5797,MATCH($M$4&G2,Car_Sho p!$C$2:$C$5797&Car_Shop!$B$2:$B$5797,0),Car_Shop!$ D:$D,COUNTIF($G$6:$G$112,Car_Shop!$D$2:$D$5797))


F6 is the field of the first variable M4 another variable..noting 'status'
it compares f6 'job category' g6 is result to show the open unassigned employee id for each category.



the second sheet is the assignment Car_Shop sheet
column b column c column d

Category Status employee id
cat 1 U 123456
cat 2 U 134598
cat 3 A 123457
cat 4 U 123456
cat 5 A 123456
cat 1 A 659874
cat 2 A 458562


the result should [and is in the builder] be the next unique empl id in g6 based on
Car_Shop b and c column..any help would be immensely appreciated...