 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Match Returns #N/A
With the following in my sheet... A B C 1 4 2 5 {=MATCH(5,A2:A2,0)} 3 6 {=MATCH(5,ABS(A2:A2),0)} B2 returns 1, while B3 returns #N/A. Why? -Rishi You can't have an array range as an argument to ABS( ) - it must be a single cell or number. Pete On Feb 29, 3:42 pm, rishiy...@gmail.com wrote: > With the following in my sheet... > [quoted text clipped - 6 lines] > > -Rishi > A B C > 1 4 > 2 5 {=MATCH(5,A2:A2,0)} > 3 6 {=MATCH(5,ABS(A2:A2),0)} > > B2 returns 1, while B3 returns #N/A. Why? Because as written, ABS is not returning an array. Try one of these: Array entered: =MATCH(5,ABS(A1:A10),0) Normally entered: =MATCH(5,INDEX(ABS(A1:A10),,1),0)  SignatureBiff Microsoft Excel MVP You can't have an array range as an argument to ABS( ) - it must be a single cell or number. Pete On Feb 29, 3:42 pm, rishiy...@gmail.com wrote: > With the following in my sheet... > [quoted text clipped - 6 lines] > > -Rishi
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.