Millie said:
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
