+ Reply to Thread
Results 1 to 6 of 6

Matrix problem

  1. #1
    Registered User
    Join Date
    06-20-2009
    Location
    oslo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Matrix problem

    Hi,

    I want to find a formula which can help me with my problem in the excel sheet. I want to get the number in cell c14 by changing the year in cell c13 and the name in cell b14. That is, if I change cell c13 from 2008 to 2009 and cell b14 from EBIT to EBITDA, I will get the number 120 in cell c14.

    Hope someone can help me with this small problem (but big enough for me, hehe)
    Attached Files Attached Files
    Last edited by stianabra; 09-22-2010 at 03:17 PM.

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Only a small problem (but big enough for me)

    Hi. I'm happy to help you!!! But you've got 27 posts!!! And you didn't read forum rules yet. Please do that. Especially rule # 1
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Only a small problem (but big enough for me)

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    06-20-2009
    Location
    oslo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Matrix problem

    Ok, can you help me now?

  5. #5
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Matrix problem

    =index(c4:e7,match(b14,b4:b7,0),match(c13,c4:e4))

  6. #6
    Registered User
    Join Date
    06-20-2009
    Location
    oslo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Matrix problem

    Great! Thanks

+ Reply to Thread

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