When I run this code, the watch value displays the correct values, but when I plug the formula into my worksheet, it displays different values.
This is what I used in the Immediate window
?TOP(Worksheets("Exp").Range("C24"),Worksheets("Exp").Range("PT_Exp_Total"),1)
It returns:
Hair Cut...