Forum Discussion
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 attached picture. Thanks in advance for assistance.
2 Replies
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.
=LOOKUP($A9,$G$2:$G$5,$I$2:$I$5)
untested
Hope I could help
Nikolino
I know I don't know anything (Socrates)
