Lookup data in 2 pivot tables

I have an excel workbook that brings in data using an ODBC connection - these are production records from jobs produced.

I'm trying to create a Vlookup in the "Waste Pivot" sheet that takes a value (prod order) in that pivot, looks up that order in the sheet 2 pivot, and returns the value in the "sum of qty" field.

From what I can tell, you can't use Vlookup with pivot tables...

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Microsoft Access, Visual Basic

Lihat lagi: create pivot table from multiple worksheets excel 2016, create a relationship between tables in excel 2016, pivot table from multiple tables, pivot table excel, how to add values from two pivot tables, combine two pivot tables, how to compare two pivot tables in excel 2013, is it possible to compare two pivot tables, cnet excel working pivot tables, use excel short data, using excel pivot tables aspnet, pivot tables excel, excel lookup data internet, change odbc data source pivot tables, generate pivot tables excel net, sample business analyst resume excel skills pivot tables, hoe use excel data input, writing excel pivot tables xml, excel update existing pivot tables connection, create excel pivot tables aspnet

Tentang Majikan:
( 0 ulasan ) Harwood Heights, United States

ID Projek: #19478374

Dianugerahkan kepada:


i can do this. i have good command over Ms excel especially pivot able, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks

$60 USD dalam sehari
(18 Ulasan)

Hi. Great app writer for your projects. I have writen excel vba for many years. I am ready to write your project. Thank you for visiting my profile

$40 USD dalam 2 hari
(0 Ulasan)

6 pekerja bebas membida secara purata $87 untuk pekerjaan ini


I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, advanced excel based tools, VBA automation, and data processing. I have successfully completed similar projects, please hav Lagi

$200 USD dalam sehari
(23 Ulasan)

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly com Lagi

$30 USD dalam 0 hari
(7 Ulasan)

i can write fastly in a short period of time. you can hire me for an assured decent work. thanks i have a good english professiency

$35 USD dalam 2 hari
(0 Ulasan)

WORK ON TIME WITH NEAT AND CLEAN CONTENT .................................................................

$155 USD dalam 3 hari
(0 Ulasan)