I have a piviot table that returns a list of values.
( 311022,311024,311032,408505,410009,735022.....) in numeric order with some values skipped.
When I copy and paste these values on to another sheet then do a lookup_value I am able to find the value. But now there is a new value in the table that is not in numeric order. The value is 311029. When I lookup this value I get 311024. Other than resorting the list what can be done to find the correct value.
( 311022,311024,311032,408505,410009,735022.....) in numeric order with some values skipped.
When I copy and paste these values on to another sheet then do a lookup_value I am able to find the value. But now there is a new value in the table that is not in numeric order. The value is 311029. When I lookup this value I get 311024. Other than resorting the list what can be done to find the correct value.