limitation to Match formula?

  • Thread starter Thread starter Melissa
  • Start date Start date
M

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?
 
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
 
Back
Top