+ Reply to Thread
Results 1 to 2 of 2

How to pick a value from a array of data corresponding to column and a row

  1. #1
    Registered User
    Join Date
    08-29-2011
    Location
    CHENNAI, INDIA
    MS-Off Ver
    Excel 2007
    Posts
    6

    How to pick a value from a array of data corresponding to column and a row

    In the given table first row has Months and first column has year
    and the array of values, If i give the year and month then the corresponding value should be picked up
    what to do? how to do? Kindly help to solve this.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: How to pick a value from a array of data corresponding to column and a row

    Are you trying to do this in VBA? Your request isn't completely clear, but check if the following is similar to what you are looking for:

    Please Login or Register  to view this content.
    If you see the code, you can pick your value using day and month to identify the row and column of the cell that corresponds to it. I hope that helps.
    .?*??)
    `?.???.?*??)?.?*?)
    (?.?? (?.?
    Pichingualas <---
    ??????????????????????????

    Wrap your code with CODE TAGS.
    Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
    Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).

+ 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