Returning next available number in a sequence

[Jdsonne31]

I am looking on how I can return the next available 3 digit sequence based on whether it is labeled as available or unavailable. In the image below, I want the ID in yellow to return 003

 

[JamesCanale]

I've made it filter so that the region and DC match what is on the top - I don't know if you needed that, if your list had a bunch of more stuff in it.

MrExcelPlayground23.xlsx
	A	B	C	D	E	F	G	H	I
1	Region	050
2	DC	001	50001
3	ID	003
4
5
6
7					Region	DC	Thing	Available	ID#
8					050	001	50001	unavailable	001
9					050	001	50001	unavailable	002
10					050	001	50001	available	003
11					050	001	50001	unavailable	004
12					050	001	50001	available	005
13					050	001	50001	unavailable	006
14					050	001	50001	available	007
15					050	001	50001	available	008
16					050	001	50001	available	009
Sheet25

Cell Formulas
Range	Formula
B3	B3	=TAKE(FILTER(I8:I16,(E8:E16=B1)*(F8:F16=B2)*(H8:H16="available")),1)

 

[Cubist]

XLOOKUP returns the first result.

=XLOOKUP(1,(E8:E16=B1)*(F8:F16=B2)*(H8:H16="available"),I8:I16)