I perform a vlookup command on a pivot table. Results are not same as I expect. Is there any limitations for performing vlookup command on a pivot table?
And very oddly when I perform isnumber command and numbers in pivot table, the result is: FALSE.
I have to add, Isnumber returns FALSE for original table, where pivot table is base on.
And very oddly when I perform isnumber command and numbers in pivot table, the result is: FALSE.
I have to add, Isnumber returns FALSE for original table, where pivot table is base on.