VLOOKUP
 

Is it possible to do a VLOOKUP function in a PivotTable?

VLOOKUP
 

"Millie" wrote:
Is it possible to do a VLOOKUP function in a PivotTable?

Hazarding some thoughts as to your underlying intents ..

To prepare the pivot for use as a lookup table, the col blanks need to be
filled in ..
First, do a copy n paste special as values of the pivot in a new sheet
Then "fill in" the col blanks using the Sub FillColBlanks() by Dave Peterson**

**See Debra Dalgleish's:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells

Fill Blank Cells
Fill Blank Cells Programmatically*
*Sub FillColBlanks() by Dave Peterson
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---