Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default if(and(isnumber(match(... vs if(and(match(...

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default if(and(isnumber(match(... vs if(and(match(...

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default if(and(isnumber(match(... vs if(and(match(...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
index match array function-returning only first match, need last. Julie Olsen Excel Worksheet Functions 3 December 29th 06 01:50 AM
Isnumber Match Index help request Juls Excel Discussion (Misc queries) 7 October 23rd 06 05:16 PM
if, Isnumber, Match, &index query Juls Excel Discussion (Misc queries) 0 October 23rd 06 03:07 AM
Lookup? Match? pulling rows from one spreadsheet to match a text f cjax Excel Worksheet Functions 3 July 21st 06 03:51 PM
problem with =isnumber(match(right(... Luke Excel Worksheet Functions 17 September 25th 05 02:01 AM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"