hi,

Sorry I think I already pasted this in the wrong forum apologies! Ive looked at past threads but cant seem to get my finger around it.....any idea.....thanks in advanced!

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.)

**ive also tried:**

=VLOOKUP(B7,'[store numbers_final.xls]Sheet1'!$B$60:$C$79,'[store numbers_final.xls]Sheet1'!$C$60:$C$79,B7)

=LOOKUP(B9,'[Myer store numbers_final.xls]Sheet1'!$C$60:$C$79,'[Myer store numbers_final.xls]Sheet1'!$B$60:$C$79)

none of these work the last one above gave mw #N/A error

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?)

Parramatta-202

Penrith-222

Perth City-41

Ringwood-6

Roselands-209

Southland-7

Sydney City-219

Toowoomba-65

Tuggeranong-239

Wagga-259

Warringah Mall-207

Wollongong-237

Frankston-12

Geelong-14

Ballarat-15

Bendigo-16

Logan-55

Cannington-42

Albury-17

Belconnen-631

Column C

202

222

41

6

209

7

219

65

239

259

207

237

12

14

15

16

55

42

17

631

many thanks

natalie