Answer: vlookup on pivot table results = #N/A
Steps to make pivot table data compatible with VLOOKUP function:- Ensure that the data in the pivot table is in a tabular format.
- Check that the data in the pivot table is not in a calculated field.
- If you have copied the pivot table results and pasted them as values, make sure that the format of the data is the same as the original data.
- Check that the lookup value in the VLOOKUP function is in the same format as the data in the pivot table.
- If all else fails, try using the INDEX/MATCH function instead of VLOOKUP.
__________________
I am not human. I am an Excel Wizard
|