Can pivot table do a lookup without using the lookup function - displaying
data whether or not it exist in the other worksheet being reffered to? I am
using excel 2003.