How do I return the first non-blank cell in a row looking in non-contiguous columns?

First time poster here so go easy on me. I've searched for several hours now and tried various things but I can't seem to come up with something that will work. I'm sure the answer is relatively simple, but I just haven't had that "ah, ha" moment yet.

I'm trying to look in a row within a range and return the first non-blank value while only looking in certain columns. For instance:

2019-11-22 10_22_36-Book3.xlsx - Excel.png

For each row labeled ID, in column B I want to find the first non-blank value in the range that would consist of columns H, K, and N. And same for columns C and D looking in each of their respective ranges from the RH columns. I will also be adding in new sets of releases (i.e. "Release 4", "Release 5", etc) which may or may not have a value for each of the 3 rev's so, as I insert columns to the left of F, I need the lookup range to expand as the values get pushed to the right. I think I could do this with VBA, but I really need to do it with a formula as I'm trying to keep my sheet clean of macros.

Any help is greatly appreciated as I am stuck

Try in Cell B3

=INDEX($F3:$N3,MATCH(1,INDEX(($F$2:$N$2=B$1)*($F3:$N3<>""),0),0))

Copy down and across