forza fiume
New Member
- Joined
- Nov 17, 2022
- Messages
- 8
- Office Version
- 2019
- Platform
- MacOS
Dear Mr Excel,
of course, I have a problem.
In the hotel where I work, we have to make a daily report of sold souvenirs and other items. I solved columns K,L and M but I have a problem with column N.
For now in cell N3 formula is =XLOOKUP(K3;$A$3:$A$301;$D$3:$D$301;0; 0) and that is fine for one day.
My wish is that column N show value depending on the date chosen in N1( drop-down list). Which formula can choose D, E, F ...etc. for every day in a month
Daily report should be saved like a PDF to send to the bookkeeper.
Excel file must have a sheet for every month.
thank in advance
PS.
Sorry on my broken english
of course, I have a problem.
In the hotel where I work, we have to make a daily report of sold souvenirs and other items. I solved columns K,L and M but I have a problem with column N.
For now in cell N3 formula is =XLOOKUP(K3;$A$3:$A$301;$D$3:$D$301;0; 0) and that is fine for one day.
My wish is that column N show value depending on the date chosen in N1( drop-down list). Which formula can choose D, E, F ...etc. for every day in a month
Daily report should be saved like a PDF to send to the bookkeeper.
Excel file must have a sheet for every month.
thank in advance
PS.
Sorry on my broken english