+ Reply to Thread
Results 1 to 2 of 2

Vlookup if contains

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Vlookup if contains

    Hi all,

    I am looking for a formula where it checks a cell, looks if it contains one of 5 options (in a table) and returns the correct value (from same table). Any ideas?
    So maybe a combination between search and vlookup or search and index match? The fact that should check for more than one value seems to be the hard part...

    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    2,581

    Re: Vlookup if contains

    It doesn't seem to be hard. but attaching an example would make it easier.

    iferror(vlookup(value to check, 5values in a range,1,0),"value not found") would be a start, but you have provided no ranges to change it, likewise where might the values be found

    Attach a sample workbook. 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.

+ 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. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  2. [SOLVED] When vlookup ragnes is mutiple: How do vlookup value finding occurrence against coresspond
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 07-07-2015, 09:32 AM
  3. Replies: 3
    Last Post: 12-04-2014, 01:27 PM
  4. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  5. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Replies: 5
    Last Post: 07-29-2009, 07:53 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