IF cell contains (multiple values) then show same in

[Kapz]

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?

[unit285]

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?

[Kapz]

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.

[unit285]

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.

[Kapz]

All good! Have uploaded copy to assist...

[Gregb11]

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.