Jul 01 2021 01:17 AM
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.
Jul 01 2021 01:41 AM
=LOOKUP($A9,$G$2:$G$5,$I$2:$I$5)
untested
Hope I could help
Nikolino
I know I don't know anything (Socrates)
Jul 02 2021 01:14 PM
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.