Sheet-1: I have dates in B5:B14 and some values in c5:c14 (and entries goes on for 1 year)
Likewise,
Sheet2: I have dates in E5:E14 and some values in F5:F14 (and entries goes on for 1 year)
Sheet-3: I need a result table, where all dates should align in a single column H and its equivalent values in I column
I tried, Offset, lookup, index etc, but i failed.
Thus i seek your help.
Sheet-Sample is attached
Thank U
Likewise,
Sheet2: I have dates in E5:E14 and some values in F5:F14 (and entries goes on for 1 year)
Sheet-3: I need a result table, where all dates should align in a single column H and its equivalent values in I column
I tried, Offset, lookup, index etc, but i failed.
Thus i seek your help.
Sheet-Sample is attached
Thank U