+ Reply to Thread
Results 1 to 5 of 5

COUNTIF and VLOOKUP with 'Multi-Input' cells

  1. #1
    Registered User
    Join Date
    05-31-2022
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    3

    Question COUNTIF and VLOOKUP with 'Multi-Input' cells

    Hi forum,

    I have several 'multi-input' (With a dropdown macro for multi inputs) cells which look like this:

    Value1
    Value2
    Value3

    Now I want to use 'COUNTIF' and 'VLOOKUP' but it isn't working by default.
    Any hints how to WORKAROUND?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,463

    Re: COUNTIF and VLOOKUP with 'Multi-Input' cells

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    05-31-2022
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    3

    Re: COUNTIF and VLOOKUP with 'Multi-Input' cells

    Attached

    Let me know if anything is unclear.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-05-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    155

    Re: COUNTIF and VLOOKUP with 'Multi-Input' cells

    Please use the below formula in column H

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The * is looking for the word in a string, if you copy and paste the cell where the dropdown is each fruit is one continuous word. see column I as an example.

    Hope that helps.

    With regards to column C, the only way I can think of having it is using the formula in C3, this could become a very long formula and it doesn't have the formatting you will want.

    You will be better off using a macro but this isn't my area.
    Attached Files Attached Files
    Last edited by Farley945; 05-31-2022 at 08:48 AM. Reason: updated answer

  5. #5
    Registered User
    Join Date
    05-31-2022
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    3

    Re: COUNTIF and VLOOKUP with 'Multi-Input' cells

    Quote Originally Posted by Farley945 View Post
    Please use the below formula in column H

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The * is looking for the word in a string, if you copy and paste the cell where the dropdown is each fruit is one continuous word. see column I as an example.

    Hope that helps.
    This one is working like a charm - Thanks for that!

    Any 'macro power user' who can help with the second one?

+ 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. [SOLVED] Help with Vlookup plus adding a user-input number of adjacent cells
    By rham243 in forum Excel General
    Replies: 2
    Last Post: 08-10-2015, 04:39 PM
  2. Replies: 0
    Last Post: 07-28-2013, 10:24 AM
  3. VLOOKUP to find multi results and sum adjacent cells
    By Phatmat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2013, 09:35 PM
  4. Count it multi criteria accross multi cells
    By jfoley5197 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2013, 03:42 PM
  5. Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  6. Multi-Sheet, Multi-Table Vlookup possible?
    By cte in forum Excel General
    Replies: 6
    Last Post: 09-11-2010, 11:18 AM
  7. Can't COUNTIF an array VLOOKUP without intermediate cells
    By studog in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2009, 03:16 AM

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