MATCH Function #N/A Error

[katmarsar]

I am trying to use the MATCH function to identify the relative position of a value within in a range (a single row of multiple columns). The problem is, the range is unsorted and has zero values and consequently the function returns an #N/A error. Is there a better function to use or a workaround?

Thanks.

 

[Elise4Excel]

You are probably done with whatever project you were working on, however I came across this because I was having the same problem and I think I figured it out. Put your cursor in the formula bar and press "CTRL + SHIFT + ENTER". Because of the array in the formula, you have to press this. Hope it helps for the future.

Thanks for the suggestions, but none of them seem to resolve the problem. It appears 99% likely that the problem is in the range of data, but I cannot figure it out.