DashboardNovice
Member
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?
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?