limitation to Match formula?

[Melissa]

I am using a vlookup formula with a Match formula as below:
=vlookup(lookup_value,array,match(lookup_value,array,0),0)

This formula works well when the Match portion = 1 to 26. However, when it
goes above 26, like 27 or 30, I get a #REF! error. I drag my formula across
the required cells so there shouldn't be any typo errors. Anyway, I have
checked and checked and can't find what's wrong.

Is there a limitation to the Match function and is there a workaround?

 

[Melissa]

Oh! I made a mistake in another part of my spreadsheet...

thanks anyway

 

[Roger Govier]

Hi Melissa

1 to 26 sounds suspiciously like the Match is A to Z.
Is that your problem?
Without seeing your exact formula and the sort of data in the ranges, one
can't say, but there is no inherent reason why Match should stop at 26