+ Reply to Thread
Results 1 to 3 of 3

Thread: How do I find a value at the intersection of a column and a row?

  1. 04-01-2010, 07:06 PM #1
    brianalucas
    brianalucas is offline
    Registered User
    Join Date
    04-01-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question How do I find a value at the intersection of a column and a row?

    I'm sure this is basic but I'm hitting a roadblock.

    I can find a value at the intersection of a column and a row if I use the Lookup Wizard but the wizard only works when the data range being referenced is within the same worksheet. But I need to be able to perform the lookup when the data source is in another worksheet and/or workbook.

    I've attached a small .xls file that shows what i'm trying to do.

    Would greatly appreciate any help you can offer. Thanks!!!!!
    Brian
    brianalucas@gmail.com
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 04-01-2010, 07:36 PM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    815

    Re: How do I find a value at the intersection of a column and a row?

    G'day and welcome to the forum

    Try this way and copy drag down

    =INDEX(data!$B$2:$K$6,MATCH(A2,data!$A$2:$A$6,0),MATCH($A$1,data!$B$1:$K$1))

    You have your row and column index the wrong way

    Cheers

    RC
    Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks


    I don't void confusion, I create it
    Reply With Quote Reply With Quote
  3. 04-01-2010, 08:02 PM #3
    brianalucas
    brianalucas is offline
    Registered User
    Join Date
    04-01-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How do I find a value at the intersection of a column and a row?

    Awesome. Thanks very much. You totally helped me saved a ton of time.
    Reply With Quote Reply With Quote
+ 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)

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.2.0