+ Reply to Thread
Results 1 to 3 of 3

INDEX dosent work???

  1. 10-09-2013, 03:39 PM #1
    ExcelBG
    ExcelBG is offline
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    INDEX dosent work???

    Hello everyone,

    See attached file and pls help me if u can...description is inside

    Thank u in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-09-2013, 03:42 PM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: INDEX dosent work???

    maybe =INDEX(INDIRECT(INDEX(I2:J6,E2,2)),MATCH(Sheet1!C2,Sheet2!A:A,0),2)
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 10-09-2013, 03:59 PM #3
    ExcelBG
    ExcelBG is offline
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: INDEX dosent work???

    Thank u JieJenn!
    It works!!!

    Best regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data validation with the table feature on another worksheet dosent work
    By Masun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2013, 06:54 AM
  2. Index Match Index Formula work slow
    By avk in forum Excel General
    Replies: 9
    Last Post: 03-07-2012, 02:19 PM
  3. input box dosent quite work
    By babar48 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2011, 07:33 PM
  4. [SOLVED] why sum dosent work.
    By EXCEL　NEWS in forum Excel General
    Replies: 9
    Last Post: 06-01-2005, 05:05 PM
  5. excel: external data "data range properties" button dosent work
    By HelpMuchNeeded in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2005, 05:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1