+ Reply to Thread
Results 1 to 3 of 3

search columns based on comboboxes

  1. 02-21-2019, 06:07 PM #1
    MrThor
    MrThor is offline
    Registered User
    Join Date
    07-20-2018
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    8

    search columns based on comboboxes

    Hi, I want to find a code helping me searching for numbers based on numbers in comboboxes.

    If combobox1 shows number 1, combobox2 shows number 2 and combobox3 shows number 3, then I want to find the row were column A has the value from combobox1, column B has the value from combobox2 and column C has the value from combobox3. When I have found the row, I need to display the number in cell A1 in sheet1. The comboxes are on a userform and the Columns that need to be searched are in sheet2.

    Anyone have a good idea?
    Reply With QuoteRegister To Reply
  2. 02-22-2019, 02:58 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: search columns based on comboboxes

    Hi.

    This is interesting.

    I have an idea that I need to test. BRB.

    Ok the Test Was Successful.

    This Array Formula worked for me. Entered using Ctrl Shift Enter

    =MATCH("4:9:160",A:A&":"&B:B&":"&C:C,0)

    It Returned 4, which is the row where column A =4, Column B = 9, Column C =160.

    So get your macro to create the formula in Sheet1

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 02-22-2019 at 04:16 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 02-24-2019, 01:25 PM #3
    MrThor
    MrThor is offline
    Registered User
    Join Date
    07-20-2018
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    8

    Re: search columns based on comboboxes

    Thank you for the help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search a field based on two or more columns
    By sokunthaneth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2018, 12:44 AM
  2. Populating comboboxes based on selection of values from another comboboxes & capturing val
    By excel_126 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2015, 02:02 PM
  3. Help! Entire Row Hidden - w/Two ComboBoxes - Doesn't Hide the ComboBoxes
    By ocnmel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2015, 09:27 AM
  4. Return Values From 2 Columns Based On Selections From 2 Comboboxes
    By Joe-XT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 03:23 PM
  5. [SOLVED] Userform to search two conditions (from comboboxes) to populate textbox
    By mattyh555 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2012, 04:51 PM
  6. [SOLVED] Search and copy value based for multiple columns
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2011, 12:23 PM
  7. Search columns based on name?
    By chris-uk-lad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2008, 11:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1