Results 1 to 5 of 5

Index function ALMOST works!

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2008
    Location
    Madison, WI
    Posts
    2

    Index function ALMOST works!

    Hi,

    I'm stuck with an indexing problem. The value that is returned is off by 2 rows everytime. When I evaluate the formula, it shows the correct row just before the indexing function does it's thing.

    I have a cell phone bill for 20 or so phones and am trying to isolate one number at a time and evaluate usage. The first sheet is my data, the second is sheet ("Breakdown") is where I enter the number in A2 that I want to look at. When I do, it misses the first 2 rows and picks up 2 extra from the following phone number.

    I'll attach and see if anyone can help. Thanks in advance!
    Attached Files Attached Files
    Last edited by moxnix; 03-31-2009 at 03:42 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