Results 1 to 6 of 6

IF cell contains (multiple values) then show same in

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2016
    Location
    Perth, Australia
    MS-Off Ver
    10
    Posts
    9

    IF cell contains (multiple values) then show same in

    Hi Guys,

    I have 2 tabs on a spreadsheet called MASTER and PRINT REVIEW

    On MASTER I will be adding 5 different texts to cells called "AL" "CD" "DIL" "PSH" "LSL"

    On the PRINT REVIEW sheet I want it to search the exact same cell on the MASTER tab and check if it contains only "AL" "CD" or "DIL" not the other two texts and if it does contain that text then display the same text on that tab. If it doesnt contain one of those 3 types and the cell has one of the other 2 types or is blank I want it to display no value in that cell.

    Any help on this?
    Attached Files Attached Files
    Last edited by Kapz; 09-15-2021 at 10:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show multiple values from another sheet
    By SPIG in forum Excel General
    Replies: 5
    Last Post: 10-14-2020, 11:16 AM
  2. [SOLVED] Show Multiple Values in Multiple Cells IF Values in Column 'I' =>1
    By markrc139 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2019, 12:12 PM
  3. Replies: 1
    Last Post: 10-11-2017, 02:37 AM
  4. Multiple values, show second or third
    By Excelsior67 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2015, 02:14 AM
  5. VBA to Show/Hide multiple shapes based on cell values
    By Mike_Taylor16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2013, 03:29 PM
  6. Replies: 12
    Last Post: 05-10-2013, 11:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1