Thread
:
index/Match Misbehaving
View Single Post
#
10
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_]
external usenet poster
Posts: 3,346
index/Match Misbehaving
I have to ask, why wouldn't you show the formula to all of us?
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"ryguy7272" wrote:
Biff, what is your email? I tried the one @comcast but it bounced back to me.
Please send me an email.
Thanks,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Shane Devenshire" wrote:
Hi,
Why not show us your formula and some sample data?
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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''.
Reply With Quote
Shane Devenshire[_2_]
View Public Profile
Find all posts by Shane Devenshire[_2_]