Results 1 to 2 of 2

Finding intersecting row and column on data chart based on data input...

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Finding intersecting row and column on data chart based on data input...

    Hello,

    In my table I want to create a user form where the individual would enter a number which would correspond for the Header Row.
    and
    The user would also enter a Number that would correspond for the first main column (Column B).

    Based on the numbers entered, I want to find the next highest number.

    For example if 61 is entered 66 would be chosen.
    -Same would be for the numbers entered to find the column.

    Based on the numbers entered I would like to find the intersecting cell.

    can anyone give me some guidance on this task or some idea behind basic code I can embed in a user form?

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum column values based on intersecting criteria in row and column
    By rlbush2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2013, 03:56 PM
  2. [SOLVED] Finding data based on column and row from seperate charts
    By oreosxe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2012, 01:58 PM
  3. [SOLVED] Finding the row of a combo box selection to input data into an adjacent column
    By tb13 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2012, 11:06 AM
  4. Replies: 1
    Last Post: 08-27-2010, 02:59 AM
  5. Retreive data based on multiple column input
    By hgopp99 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2006, 05:00 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