Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index/Match Misbehaving
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''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |