Results 1 to 3 of 3

Removing #N/A... if stmt or data validation

Threaded View

  1. #1
    Registered User
    Join Date
    06-16-2010
    Location
    NS, Canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    Removing #N/A... if stmt or data validation

    =INDEX(Table!$1:$65536,MATCH('Dept Data'!$B8&"POS"&'Dept Data'!$C$7,Table!$E:$E,0),MATCH('Dept Data'!C$4&'Dept Data'!C$5&'Dept Data'!C$6,Table!$13:$13,0))

    This equation is based on various things. I have Departments with more than one POS's and I have it lookup up to 4. But having these lookups for smaller departments ( 1 - 3 POS) has created the #N/A issue. Ideally I would like a 0 to appear because the department has a roll up feature. My image files are too large to be posted...

    Essentially, the index is trying to pull data that isn't there, and returning #n/a, when I would like it to return 0. Should I fix this, or find a way to get my Roll up section (C11+R11+AB11+AV11 ect.) to exclude #n/a's. Which would be easier?
    Last edited by apcarty; 07-12-2010 at 12:10 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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