Formula to pull data from left column next to the 1st blank cell in the right column

I am trying to tell my cell to pull data from another worksheet from column A based on the first empty cell in column B.

A B
28,000 Done During Previous Contract
30,000 Billable to the Customer
SP30K Not Done
32,000 33,119
34,000 Not on Inv
36,000 37,018
38,000
40,000

My Desired result is 38000, however once the cell in column B next to 38000 is filled in my desired result would be 40000, etc.
This is the closest I go but it not working correctly...
{=INDEX(B3:B24,MATCH(TRUE,C3:C24="",0))}
I am looking for and excel formula not a macro. Thanks!

Originally Posted by Fotis1991

Try this ARRAY formula.

=index(b3:b24,small(if(c3:c24="",row(b3:b24)-2),row(b1)))

Thank you so much for replying but this gave me the result 0 with array and 34000 without. I put it into a small spreasheet. Any other suggestions. This one is really racking my brain.

Originally Posted by Fotis1991

It's because of your merged cells(rOWS 5 &6). Array formulas don't like merged cells.....

Wonderful!! Thanks again!