• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table field has values that are not in the raw data

I have a pivot table field. When I look at the filter it has values that are not in the raw data.

In the raw data, I have a VLOOKUP that returns either #N/A or some employee IDs. Then I enclosed that inside of the ISNA( ) which does evaluate to either TRUE or FALSE in the raw data as it should. But in the pivot table I see TRUE, FALSE and the same employee IDs returned from the VLOOKUP, when I should only see TRUE or FALSE.

How can the employee IDs from the VLOOKUP still show in the pivot table results when they are enclosed in the ISNA ( ) function?
 
Back
Top