Using a Vlookup on an Excel pivottable cannot find a match

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.



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


Thank you Anil, that did the trick!

1 Like

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