Using a Vlookup on an Excel pivottable cannot find a match

[bas.henssen]

Hello all,

I’m running into some issues with a Vlookup function and I was wondering if anyone could help. The function is in a workflow that is supposed to check for a value in an excel pivottable. To test, I’ve simply copied on of the values I know is in there, but running the flow provides no result.

It concerns the following pivottable:

I have tried to test with the value 13811810 (on line 4) but the result is empty.

Could you guys help me? It would be very appreciated.

Regards,
Bas

[Anil_G (Anil Gorthi)]

@bas.henssen

I guess they are taken as numbers try using value without wuotes and check1381180

Cheers

[bas.henssen]

Thank you Anil, that did the trick!