Error with Match function

**joshuar** · 10-29-2010, 02:07 AM

Hi All,

I am facing an error with Match function. The answer returned is incorrect.
Can someone help.
File attached.

Regards

**MarvinP** · 10-29-2010, 02:29 AM

Hi Josh,

You are missing the third parameter of exact match. Try
=MATCH(A2,F1:H1,0)
Give that a try.

**protonLeah** · 10-29-2010, 02:34 AM

You forgot the match type parameter, zero (exact match)

Please Login or Register  to view this content.

**joshuar** · 10-29-2010, 02:45 AM

Thanks all,
Yes the problem is solved.
Thanks again

**YitzHandel** · 08-08-2011, 11:49 AM

I have a time versus temperature plot. It is (ramp/hold) 3x, but there can be a large dip in the temperature between the 2nd hold and the 3rd ramp.

When this occurs, the Excel match will miss the 1st match data, and focus on from after the sharp rise.

Why is match finding the wrong value on the 3rd tab of the attached file?

**arthurbr** · 08-08-2011, 11:59 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.