so i have all these values in a pivot table. and i want to perform a vlookup based on all these values..
but excel can't seem to recognize the value in the pivot table and return #N/As for all of them...

how to solve this?