Forum Discussion
Solved
Working in Excel with an exported SahrePoint List into Excel.
Hi I am quite new to world of 365. I have exported a number of SharePoints lists to an Excel workbook - all in the same book just on different sheets. But I can't link (Vlookup) to this Query...
I could only make I guess that you lookup numbers. Numbers imported from SharePoint list in Excel will be presented as texts, thus in lookup column you have texts. If so you may try
=VLOOKUP(M2 & "", 'Staff Matrix'!$A:$B, 2)
SergeiBaklan Thank you so much for this response, this has resolved the issues I was experiencing.
trainingthefuture , glad it helped