Ryan; have a close look at the zipcodes (Press F2) to see if there are any
other characters present in the array data.

If this post helps click Yes
---------------
Jacob Skaria


"ryguy7272" wrote:

I created a Pivot table, and did a copy/paste special values to get rid of
the Pivot Table. Now, I try to do a simple Index/Match, and I almost always
get the lowest value in the list as a result, no matter what lookup value I
use for the Match. What could cause this? I know the zip codes (this is the
array for the index) come out as text (this file was downloaded from an
external system). That shouldn't matter, right. I'm not concerned about the
data type, I'm just looking for my Match, but can't find it. Anyway, even if
I convert the zips to number-type, the results are still wrong.

Any ideas?

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.