rentonhighlands
Board Regular
- Joined
- Jul 31, 2014
- Messages
- 134
- Office Version
- 365
- Platform
- Windows
Hello,
I want to use vlookup function. I want to lookup using data in a pivot table against data that is not in a pivot table. I tried and get #N/A error. Why?
I checked I see data in pivot table is the same data in my other sheet.
Is it that the formatting in the pivot table does not allow for vlookup to work?
I want to use vlookup function. I want to lookup using data in a pivot table against data that is not in a pivot table. I tried and get #N/A error. Why?
I checked I see data in pivot table is the same data in my other sheet.
Is it that the formatting in the pivot table does not allow for vlookup to work?