I am new to pivot tables and am attempting to build what I thought was a simple one. I have two sheets, one for customer information and the other for sales information. The Customer Information sheet contains the following: customer #, name, address, city, and zip. The Sales sheet only contains customer #, name, dates and sales quantities. In order to make it easier on myself, I combined the two sheets into one, using the Sales sheet as my main sheet and employing vlookup formulas to fill in the detail info from the Customer Information sheet. I then copy and paste values on these columns.
All of the fields listed above are to be included in the pivot table, with the dates being the column labels, quantities as the value and everything else as row labels. My problem is that all fields that were supplied via the vlookup formulas contain #N/A. All other fields that are native to the Sales sheet are shown correctly with no problems. I've googled and searched and can't seem to find solutions to this. Any thoughts?
All of the fields listed above are to be included in the pivot table, with the dates being the column labels, quantities as the value and everything else as row labels. My problem is that all fields that were supplied via the vlookup formulas contain #N/A. All other fields that are native to the Sales sheet are shown correctly with no problems. I've googled and searched and can't seem to find solutions to this. Any thoughts?
