Forum Discussion
Arturo_Guzman25
Jul 01, 2021Copper Contributor
Formula to Input Multiple Data to a Cell Range in a Certain Column
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 atta...
SergeiBaklan
Jul 02, 2021Diamond Contributor
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.