Results 1 to 2 of 2

Why error catcher doesn`t work with this formula?

Threaded View

ABSTRAKTUS Why error catcher doesn`t... 05-17-2010, 05:25 PM
pike Re: Why error catcher doesn`t... 05-17-2010, 07:31 PM
  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Why error catcher doesn`t work with this formula?

    Hi all! Errors drive me crazy! Especially when I can` get rid of them. So, I have a formula, and error catcher =IF(ISERR( does`nt work. Excel says you have a mistake in your formula. But I am sure enough I don`t. There is a formula :

    =INDEX(OFFSET(Stafflist!$B$5,MATCH(VLOOKUP($C$5,$Q$17:$R$20,2,0),Stafflist!$B$5:$B$163,0),1,ROWS(INDIRECT("Shift"&VLOOKUP($C$5,$Q$17:$R$20,2,0)))),SMALL(IF("O/T"=OFFSET(Stafflist!$B$5,MATCH(VLOOKUP($C$5,$Q$17:$R$20,2,0),Stafflist!$B$5:$B$163,0),MATCH(MAIN!$G$5,Stafflist!$C$5:$AJ$5),ROWS(INDIRECT("Shift"&VLOOKUP($C$5,$Q$17:$R$20,2,0)))),ROW(INDIRECT("1:"&ROWS(INDIRECT("Shift"&VLOOKUP($C$5,$Q$17:$R$20,2,0))))),""),ROW(A5)))

    The formula works fine, but when there is no value to return to that cell, it comes up as #NUM error. Conditional formating is not for me. These dark triangles in the corners of the cells drive me crazy as much as errors do. How do I get rid of the error in the cell if there is no value to return?
    Last edited by ABSTRAKTUS; 05-17-2010 at 06:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1