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...
Change your formula in D2 to include INT(B2) rather than just B2 - this looks for the whole number and discounts any trailing decimals which can throw off a formula looking for an exact match:
=VLOOKUP(INT(B2),Customer!A:B,2,FALSE)
Yes I work a lot with macros/VBA and that can give some 'fun'- most of the time it works perfectly.
Perfect ! I have changed it and it works without problems - thank you 🙂