Link values without vlookup using tables?

[Christof]

Can you advise if there is a better way of looking up the values in Column AE against the values in my 'StaffTable' rather than using the vlookup method i have done here.. or is that the correct way? Feels like it isnt?

 

[chirayu]

Link up the 2 tables in powerquery, load as pivot

 

[GraH - Guido]

Difficult to say based on a picture. Always better to post with a workbook and sample data.
2nd alternative is loading both tables into data model/powerpivot.

But your #N/A error might be because your lookup key is not found or does not exactly match the values in the lookup column. Perhaps there are trailing blanks, missiing values, unmatching spelling,...

 

[Christof]

Thanks.
I'm currently attempting the method of data model/ powerpivot. Then having my dashboard built up using =cubevalue formulas.
I wasn't sure whether it would be slower to do it this way as the dashboard will have formulas and slicers relating to many tables, Or if it was best to create one big table (as in the picture) and use GETPIVOTDATA formulas instead