Working with 2 tables and , my goal is to be able to get a final table that looks like the following table .

As observed in Ctable, it is a joined table of Atable and Btable, the values from the Btable are empty except for the depth field. My goal is that for each in Btable.xlsx, the needed values will be sccraped from the nearest value in range to it from the Atable.xlsx e.g. (Depth100 in Btable will get the following values NS(ft), EW(ft) and Date from Depth 206 of Atable, since 206 is closer to 100 than any other numeric values in Atable, 500 depth in Btable will get it values from 492 depth of Atable and this will occur for every depth in the Btable of depth values.

Suggestions are highly appreciated on how to get this to work in FME.