Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I have a formula =IF(C$1="","",INDEX(Sheet1!145:145,MATCH(C$1,Sheet 1!$1:$1,FALSE))). I would like to add an iserror function, that will return a blank instead of #N/A, where there is no match on sheet1! row 1:1

    Your assistance will be most appreciated

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Would this work......
    =IF(C$1="","",IF(ISERROR(INDEX(Sheet1!145:145,MATC H(C$1,Sheet1!1:1,FALSE))),"",INDEX(Sheet1!145:145, MATCH(C$1,Sheet1!1:1,FALSE))))

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Tim

    Thanks for the help, much appreciated

    Regards

    Howard

Posting Permissions

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