Good time of day!
Your task is kindda challenging and, at a first glance, requires advanced techniques. You will find my array formula in the attachment. Solution is far from ideal and there is much to improve, I just wanted to "brake the ice".
Formula:
=INDEX(Values,SMALL(VALUE(SUBSTITUTE(SUBSTITUTE("!"&((IFERROR(MATCH(Values,Block,0),0)=0)*(ROW(Values)-1)&"!"),"!0!","!999!"),"!","")),ROW()-1))
Where "Values" and "Block" are named ranges of additional value list (from 100 and on) and values from column A to block.
Bookmarks