Using Row Labels from Pivot Tables into VBA code

vlookupvba.jpg

How do I make the row labels in red string variables for the worksheet I want to search using the values below as the lookup values in a vlookup formula in VBA in the next column? I have the formula of the v lookup formula as if it was in a cell to demonstrate what i mean. If there is better way to do it without having to reference the Pivot tables that would work as well.


=vlookup("C52498",'1039264'!C1:K16,4,0)