+ Reply to Thread
Results 1 to 6 of 6

IF cell contains (multiple values) then show same in

  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.

  2. #2
    Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    323

    Re: IF cell contains (multiple values) then show same in

    I suggest uploading a copy of your workbook or at least clarify which cell or cells on MASTER will hold those 5 different values, and how do you expect it to be put on the print preview? Header or Footer?

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

    Re: IF cell contains (multiple values) then show same in

    Quote Originally Posted by unit285 View Post
    I suggest uploading a copy of your workbook or at least clarify which cell or cells on MASTER will hold those 5 different values, and how do you expect it to be put on the print preview? Header or Footer?
    Didn't plan on having the 5 values on a sheet but if required I can create a new tab called "VALUES"?

    Sorry the tab is just named PRINT REVIEW - no need to be concerned with how it prints its actually just a replica of the MASTER tab but I only want it to show the 3 values not all 5.

  4. #4
    Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    323

    Re: IF cell contains (multiple values) then show same in

    I can take a look at it in the morning.. It's late here an I been going all day lol. Feel free to upload a copy. If you have no answer yet in the morning I'll get one for u if I can.

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

    Re: IF cell contains (multiple values) then show same in

    All good! Have uploaded copy to assist...

  6. #6
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,571

    Re: IF cell contains (multiple values) then show same in

    Maybe this:

    In cell L9:
    =IF(OR(MASTER!L9="PSH",MASTER!L9="LSL",MASTER!L9=""),"",MASTER!L9)

    Copy the formula across and down to wherever you need to.

+ 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] 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