Results 1 to 7 of 7

#REF! Error in INDEX & MATCH Formula!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    #REF! Error in INDEX & MATCH Formula!

    Hi Friends,

    In the attached file, From A10:A20, I have a list of different items. From B10:B20 each item group is been mentioned and from C10:P20 day wise inventory qty is been mentioned.

    Above said details, I have to do week wise summary in B2:H5 and I have written a formula which is giving either wrong result (as shown in C3) or #REF! Error!

    Need your help to solve this issue…

    Thanks & Regards,
    Rajeshkumar R





    Attached Files Attached Files
    Last edited by Rajeshkumar R; 06-09-2012 at 09:01 AM. Reason: Query is Clarified

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