Vlookup to pivot table gives NA when result is there

[rugbytomc]

I’m doing a vllookup to a pivot, number to number. For example, 1619082625, and it gives me #N/A.
If I paste the pivot table, convert to number stored as text then format to general-the lookup works.
Is there a way I can format the numbers in the rows in my pivot table so the vlookup (or index match as also same error) will work?

 

[arthurbr]

Try

=VLOOKUP(TEXT(1619082526,0),range, column,0)

or the GEPIVOTDATA function