Is it Possible to write a Match Formula with a Defined Name Range?

squeakums

Well-known Member
Joined
May 15, 2007
Messages
629
Was trying to write a match formula with a defined name range.
=MATCH("Satisfactory",Yellow, 0)

This gives an N/A error. Is it possible?

Thanks.
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Your match formula is correct ...

Just make sure ... your named range ' Yellow ' does include Satisfactory ...
and make sure the spelling of Satisfactory is identical to the one located within ' Yellow '

Hope this will help
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,828
Office Version
365
Platform
Windows
Yes, the "#N/A" error usually means it is not finding any matches.
Note that it needs to match exactly. Something as simple as an extra space on the end of "Satisfactory " will cause it NOT to match.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,940
Office Version
365
Platform
Windows
Your named range needs to be a contiguous range, otherwise it won't work.
 

squeakums

Well-known Member
Joined
May 15, 2007
Messages
629
I was trying to write it to find any that match to give the count. Some of the fields I my defined search are not satisfactory. So, it gives an #na error.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,940
Office Version
365
Platform
Windows
Match does not give a count, it simply finds the first match.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,828
Office Version
365
Platform
Windows
If you want a count, try:
Code:
[COLOR=#333333]=COUNTIF(Yellow,"Satisfactory")[/COLOR]
 

Forum statistics

Threads
1,086,046
Messages
5,387,498
Members
402,069
Latest member
low iq excel user

Some videos you may like

This Week's Hot Topics

Top