+ Reply to Thread
Results 1 to 4 of 4

Look into a range of cells (horizontally and vertically) and return a number

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Ruse
    MS-Off Ver
    Excel 2003
    Posts
    22

    Look into a range of cells (horizontally and vertically) and return a number

    Hello guys,

    Simple (for most of you I suppose) question:

    As shown on the screenshot (file 1.jpg) I want a formula which will look horizontally and vertically at the range of cells and return the corresponded number. In this case for month 6 I need to receive number "2" for position DW. The excel file with the example is also attached.

    Thank you very much in advance!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Look into a range of cells (horizontally and vertically) and return a number

    Hello
    One way would be to use Vlookup. In cell C2 copied down:

    Please Login or Register  to view this content.
    Hope this helps.
    DBY

  3. #3
    Registered User
    Join Date
    10-03-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2016
    Posts
    38

    Re: Look into a range of cells (horizontally and vertically) and return a number

    This is such a good example of the place to use ĚNDEX & MATCH that - even if you are unsure on how they work - have a look at the attached.

    Type text below into cell C2 and then copy down.

    PHP Code: 
    =INDEX($G$2:$J$14,MATCH(A2,$G$2:$G$14,FALSE);MATCH(B2,$G$2:$J$2,FALSE)) 
    Stephen
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-04-2012
    Location
    Ruse
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Look into a range of cells (horizontally and vertically) and return a number

    You guys are awesome, thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-10-2013, 06:54 PM
  2. Replies: 5
    Last Post: 01-27-2013, 09:36 PM
  3. Merging Cells Horizontally and Vertically
    By mandyc51 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2012, 09:24 AM
  4. [SOLVED] Sumproduct vertically and horizontally
    By jimstrongy in forum Excel General
    Replies: 2
    Last Post: 03-21-2012, 04:37 PM
  5. [SOLVED] Move cells vertically to horizontally
    By Abe in forum Excel General
    Replies: 1
    Last Post: 03-22-2005, 11:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1