Formula to Input Multiple Data to a Cell Range in a Certain Column

Frequent Visitor

Good day to all, I need help on how can I display the data I entered from I2:I4 going to column P, with respect to the row from the date on column A which I have entered in G2:G4 as shown in the attached picture. Thanks in advance for assistance.

2 Replies







Hope I could help



I know I don't know anything (Socrates)


As variant 


and highlight non-empty cells with conditional formatting.

If XLOOKUP is not available you may use LOOKUP or VLOOKUP wrapping it by IFERROR to return empty string if the value is not found.