I'm trying to use the match function to identity the row a value is in, however i am running into an issue. Because of the nature of my data, I want to specify the range in which i would like to make the match. This is where I am encountering my issue. If I use the entire column in my match function, I obtain the correct result. However when I try to specify a range that includes the correct value, I get the incorrect value.
L908 = MAX(K120:K360) = 15.01 so I know this value exists in this range
=MATCH(L908,K:K,0) returns 248 (correct) K248 = 15.01
=MATCH(L908,K120:K360,0) returns 129 (incorrect) K129 = 5.3
Is there something I am missing?
Thanks.
Bookmarks