Using LOOKUP on Pivot Table

[fizzwolf]

The Workbook "Subbies Labour" has a Pivot table with Job Numbers and values against those job number and the Workbook "Job Costs Summary" has a table with Columns with Job Numbers. Is there a formula to read the results on the Pivot Table (Subbies Labour) and put against the appropriate column and row (Job Costs Summary) using the Job Number as a "LOOKUP"?

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you