Using a Vlookup on an Excel pivottable cannot find a match

Help Studio
, ,
1

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:
image

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

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

Regards,
Bas

2

@bas.henssen

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

Cheers

3

Thank you Anil, that did the trick!

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.