Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook, created by someone else, that I'm trying to clean up. The
following formula parses a long table of records: =IF(AND(ISNUMBER(MATCH(LEFT(B612,3),'[ELR expense account identification.xls]Sheet1'!$A$2:$A$12,0)),ISNUMBER(MATCH(C612,'[Frank''s expense codes--GDCS and non-GDCS.xls]Sheet1'!$A$2:$A$39,0))),"Extract","") I get the same results if ISNUMBER is removed: =IF(AND(MATCH(LEFT(B612,3),'[ELR expense account identification.xls]Sheet1'!$A$2:$A$12,0),MATCH(C612,'[Frank''s expense codes--GDCS and non-GDCS.xls]Sheet1'!$A$2:$A$39,0)),"Extract","") Any advantage to retaining ISNUMBER? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Could it be that the original creator had encountered non-numeric
entries, and included that as a workaround? Maybe the data came from a data source that has since been improved to include only numerics. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't think that's the issue. ISNUMBER is included because MATCH(....)
resolves to either a number indicating the relative position of the match or else a #N/A error if no match is found. But the IF(AND( construction, it seems, obviates the need for the ISNUMBER(...) check. It seems redundant. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "DaveO" wrote: Could it be that the original creator had encountered non-numeric entries, and included that as a workaround? Maybe the data came from a data source that has since been improved to include only numerics. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Isnumber Match Index help request | Excel Discussion (Misc queries) | |||
if, Isnumber, Match, &index query | Excel Discussion (Misc queries) | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
problem with =isnumber(match(right(... | Excel Worksheet Functions |