+ Reply to Thread
Results 1 to 3 of 3

Searching rows and columns for intersecting values

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    2016
    Posts
    4

    Searching rows and columns for intersecting values

    I'm really not even sure how best to word what I'm trying to do. I don't have any code to post just a picture (I know!) of a table to be used.

    I have created a userform to input information into a spreadsheet. Based on that info entered, I need to create a code that will search the following table and multiply an entry by the number in the cell.

    Example: If textbox1 (age) is 63 and textbox2 (column header) is "3SI" is it possible to retrieve the cell value in cell E5 via a macro? Essentially, I need to be able to search any combination of age and column header and then utilize the intersecting value.

    I realize this is asking a lot since I don't even have any code. I'm happy to read/watch tutorials. I just don't know how to concisely ask the question to find the answer.


    image_2020-11-30_135524.png

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: Searching rows and columns for intersecting values

    It would be easier to help and test possible solutions if you could attach a copy of your file. Include the userform and any code you may have. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Searching rows and columns for intersecting values

    Quote Originally Posted by revcall View Post
    ...

    Crit_1 = code that will search the following table and multiply an entry by the number in the cell

    Crit_2 = If textbox1 (age) is 63 and textbox2 (column header) is "3SI" is it possible to retrieve the cell value in cell E5

    Crit_3 = to search ... age and column header and then utilize the intersecting value ...


    Crit_2 = Crit_3 <> Crit_1


+ 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. Excel - find values searching rows first, than columns from found row
    By excel_excel_excel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-05-2018, 06:51 AM
  2. Searching across both rows and columns
    By s_twigge in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2013, 09:10 AM
  3. Searching rows and columns for string
    By utgjmb1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2013, 10:08 PM
  4. Sumif with three intersecting values
    By Steve K in forum Excel General
    Replies: 4
    Last Post: 04-20-2012, 09:29 AM
  5. Filter By Intersecting Columns
    By dpcdpc11 in forum Excel General
    Replies: 4
    Last Post: 05-06-2010, 04:33 PM
  6. [SOLVED] Searching Columns and Rows
    By Cliff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2006, 07:55 PM
  7. searching columns and rows
    By lsu-i-like in forum Excel General
    Replies: 5
    Last Post: 06-20-2005, 02:08 PM

Tags for this Thread

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