I need to add a formula in Column B that looks for the nearest column containing data to the right of Column B, and then pulls that data into the Column B cells.
For reference: Cell B2 should return the date from C2, Cell B3 should return the data from D3 (as C3 is blank). Is this an Index formula, or ?
For reference: Cell B2 should return the date from C2, Cell B3 should return the data from D3 (as C3 is blank). Is this an Index formula, or ?