Excel 2003 Match formula not working in Excel 2007
 

My user is using =MATCH($F69,Sheet1!$A$2:$A$26775,0) it worked in 2003 but
when ran in O2007 it produces a #N/A...any ideas? Thanks!

Excel 2003 Match formula not working in Excel 2007
 

That means that the entry in F69 doesn't have an exact match in
sheet1!a2:a26775. Did you change something?

Debra Dalgleish shares some debugging techniques for the =vlookup() formula, but
they apply to =match(), too.

http://contextures.com/xlFunctions02.html#Trouble



CHKMSTrainer wrote:

My user is using =MATCH($F69,Sheet1!$A$2:$A$26775,0) it worked in 2003 but
when ran in O2007 it produces a #N/A...any ideas? Thanks!

--

Dave Peterson

Excel 2003 Match formula not working in Excel 2007
 

Nothing that I know of has been changed. What should it read if the match is
suppose to be for F69?

"Dave Peterson" wrote:

That means that the entry in F69 doesn't have an exact match in
sheet1!a2:a26775. Did you change something?

Debra Dalgleish shares some debugging techniques for the =vlookup() formula, but
they apply to =match(), too.

http://contextures.com/xlFunctions02.html#Trouble



CHKMSTrainer wrote:

My user is using =MATCH($F69,Sheet1!$A$2:$A$26775,0) it worked in 2003 but
when ran in O2007 it produces a #N/A...any ideas? Thanks!

--

Dave Peterson

Excel 2003 Match formula not working in Excel 2007
 

The =match() formula will return a number/index into the array that you're
matching on.

So if it returned a 1, then your first match is in A2.
If it returned a 3242, then your first match is in A3243.
(It's one more since you started looking in A2.)

If there is no match, then you'll see the #N/A error.

CHKMSTrainer wrote:

Nothing that I know of has been changed. What should it read if the match is
suppose to be for F69?

"Dave Peterson" wrote:

That means that the entry in F69 doesn't have an exact match in
sheet1!a2:a26775. Did you change something?

Debra Dalgleish shares some debugging techniques for the =vlookup() formula, but
they apply to =match(), too.

http://contextures.com/xlFunctions02.html#Trouble



CHKMSTrainer wrote:

My user is using =MATCH($F69,Sheet1!$A$2:$A$26775,0) it worked in 2003 but
when ran in O2007 it produces a #N/A...any ideas? Thanks!

--

Dave Peterson


--

Dave Peterson