trying to do a lookup function with a pivot table. the data below is stored in a different wrk book to that of the pivot.
I have codes in the pivot which i want to return name and code (as below) once lookup function is used.
this is what i tried: lookup('[store numbers_final.xls]Sheet1'!$B$60:$C$79,'[store numbers_final.xls]Sheet1'!$C$60:$C$79,m7)
(m7-Cell where i want the answer to my formula placed.)
Look up table:
Column B (in seperate workbook)
text to return in column next to pivot table: (or is it possible to return into a column inserted into the pivot?)