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?

Oh! I made a mistake in another part of my spreadsheet...
:)
thanks anyway

"Melissa" wrote:

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?

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

--

Regards
Roger Govier

"Melissa" wrote in message
...
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?