ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   can a vlookup be used in a pivot table to extract data for graphs (https://www.excelbanter.com/excel-programming/386727-can-vlookup-used-pivot-table-extract-data-graphs.html)

James D. Sheehan

can a vlookup be used in a pivot table to extract data for graphs
 

--
James D. Sheehan

Jon Peltier

can a vlookup be used in a pivot table to extract data for graphs
 
You can use a pivot table as the lookup range of a VLOOKUP formula. Set up
the formula as if it isn't a pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"James D. Sheehan" wrote in
message ...

--
James D. Sheehan





All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com