I am a first time user of this site so hope the image I took of my spreadsheet comes through! (If not can someone tell me what I’m doing wrong!). I am aged 72 so not the sharpest tool in the box anymore (if ever!).
I’d be very grateful if someone could tell me how to achieve the result shown in my spreadseet and also decribed below.
If the attachment isn’t visible:
My spreadsheet contains a ‘table’ of 3 columns and 28 rows (A9:C30). The Titles of the columns are: Day [of week], Date and Value.
i.e. Row 10 contains: Mon, 19/6/2023, 7
Row 11 contains: Tue, 20/6/2023, 18
etc
Dates are in true date order and are formatted as Category Date and Format 31/12/99. Values are formatted as Category Number and Format General.
I want the Value from Column C that matches Today’s date to appear in a separate Cell D6 titled “Today’s Value”.
I have managed to pick up the required Row (from Column B) containing Today’s date by using =MATCH(TODAY(),B10:B30,0)+9 [9 being the offset from the first row]. That gives me the result 24.
I need help to enable me to put the value that appears in Column C that matches Today() [which is Cell C24 and has the Value ‘35’ in the my example) into a cell outside of the ‘table’ called TODAY’S VALUE (actually Cell D6 in my spreadsheet).
Thank you in advance 
LibreOffice 7.5.4.1
OS macOS 10.13.6 (High Sierra)