I am using a vlookup formula with a Match formula as below:
=vlookup(lookup_value,array,match(lookup_value,arr ay,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?