If I register a date that doesn't excist in the table, I want the values for the nearest previous dato.
Please see the attached file.
If I register 14. april I want the values 128 / 114
or if I register 10. april I want 139 / 196.
How can I use the XLOOKUP for this operation?
Bookmarks