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