Hello, I have a data set from A1:H2 and seeking solution in I1 and I2 from Reference list in A7:B15.
For Bob, I need to lookup the values in A1:G1 against the reference list and return the value corresponding to the last nonblank instance.
Thanks in advance!
<tbody>
<colgroup><col...