Results 1 to 4 of 4

Excel 2007 : Similar formulas but only one works....

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    40

    Similar formulas but only one works....

    I'm a bit stumped.
    Two formulas as shown below being used in conditional formatting.

    formula 2 works a dream.

    Formula one when I try to enter it in conditional formatting is giving a formula error.

    I can't see any difference, apart from accessing different cells, so why won't formula 1 work...is there something I can't see.

    formula 1
    MATCH($A1&"@"&$I1&"@TRUE",INDEX($AO$1:$AO$200&"@"&$AX$1:$AX$200&"@"&($BD$1:$BD$200>=0.2),0),0)

    formula 2
    MATCH($A1&"@"&$H1&"@TRUE",INDEX($AO$1:$AO$200&"@"&$AP$1:$AP$200&"@"&($AV$1:$AV$200>=0.2),0),0)

    Thanks in advance for any help...
    Rob
    Last edited by Rob44; 11-30-2011 at 08:47 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