Forum Discussion
Pivot and vlookup
Hello, I have made a pivot table, where I use a field in the filter to lookup another informations. For example I use the customer number as a filter in the pivot - but I also use it to 'vlookup...
Try simply to compare value for changed number with one in lookup array, like =Cell1=Cell2
Perhaps data type was changed from number to text (check the cell by =ISTEXT()). Or non-printable character was added (check by =LEN() ). Or something else. As mathetes mentioned without sample file it's hard to say something concrete.