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