Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index and Match results vary in Excel 2003 and 2007 | Excel Discussion (Misc queries) | |||
Why Excel 2003 VBA program not working in Excel 2007? | Excel Programming | |||
Simple Excel 2003 macro not working in Excel 2007 | Excel Programming | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Pivot in excel 2003 is not working when open in excel 2007 | Excel Worksheet Functions |