+ Reply to Thread
Results 1 to 2 of 2

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

  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

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

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

    Hi swade

    Try the Code in the attached...
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

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