Forum Discussion
Solved
Lookup and Match Data from another spreadsheet
Hi and please bear with me on this one, Excel is not my functions are not my strongest point. A task I have been presented with is to total up the working hours logged per individual AND per depa...
If I understand correctly, you want to have the "Department" in the extracted report. Use xlookup: =XLOOKUP(B2,[Master.xlsx]Sheet1!$B:$B,[Master.xlsx]Sheet1!$C:$C)
If I understand correctly, you want to have the "Department" in the extracted report. Use xlookup: =XLOOKUP(B2,[Master.xlsx]Sheet1!$B:$B,[Master.xlsx]Sheet1!$C:$C)
This is exactly what I needed, many thanks for the solution