Yeah, I tried that. I just keep getting the last number in the index list.
I've under Index/Match thousands of times before; can't figure out why it's
not working now.

Anything else?

Ryan---

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


"T. Valko" wrote:

What could cause this?

Using a match_type argument of 1 (or TRUE or omitted) when the data is not
sorted in ascending order.

--
Biff
Microsoft Excel MVP


"ryguy7272" wrote in message
...
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''.