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

Copper Contributor

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

@Arturo_Guzman25 

 

=LOOKUP($A9,$G$2:$G$5,$I$2:$I$5)

untested

 

 

Hope I could help

 

Nikolino

I know I don't know anything (Socrates)

@Arturo_Guzman25 

As variant 

=XLOOKUP([@Date],$G$2:$G$4,$I$2:$I$4,"")

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.