Results 1 to 3 of 3

If formula with index, match error

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    67

    If formula with index, match error

    Hi Guys,

    Could some have a look at this formula for me and try and see why it isnt working. It should bring back a value from list 1 if it says CL/Spouse and from another list if it doesnt, but the cell is just returning #VALUE


    =IF(B18="CL/SPOUSE",INDEX(CONPOINTS!B112:C161,MATCH(F18,CONPOINTS!A112:A161,0),MATCH(C18,CONPOINTS!B112:$C$112,0),INDEX(CONPOINTS!D113:E161,MATCH(F18,CONPOINTS!A112:A161,0),MATCH(C18,CONPOINTS!C112:D112,0))))



    thanks everyone
    Last edited by toclare84; 10-01-2010 at 08:44 AM.

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