Forum Discussion
x Lookup help please
Hi - I am new to X- Lookup and I am trying to use the formula to look up 2 criteria's, and return a value based on these. The data table is as below: In a separate table, I want to extract ...
mtarler thanks for those suggestions, I will give them a try. I have tried a pivot table, but the issue is that I want the log on times to be horizontal, and the names and dates vertical. The pivot table will only allow all to be vertical e.g.
Whereas I would like it to be displayed like this
| 21/08/2023 | 22/08/2023 | 23/08/2023 | |
| Ann | 9:00 | 9:00 | 9:00 |
Any suggestions?
