Hello Excel Guru's,
I am trying to show a value if only specific words do not show:
Formula in col BL, looks for specific words in Col E and Col M, if the text isn't in Col E & M then return the value in Col BL.
Specific words if they are in Col E & Col M:
Raw, Prod, Fill, Orange, Apple. Show $0 in BL
I created a defined name (Formulas > Name Manager)
MyList2 = "RawProdFillOrangeApple"
Then used this formula in BL2 copied down
Does that work for you?Formula:
Please Login or Register to view this content.
Last edited by ChemistB; 01-25-2021 at 04:47 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi ChemistB,
Thank you so much for the offer to help. Is there a way to have the list on a second tab due to the list of text will grow. I would then name the range on the second tab column A1-A7 List3. I have uploaded the file.
Or try this in BL2
=BK2*(SUMPRODUCT(COUNTIF(Sheet2!A:A,E2:M2))=0)
Hello Phuocam,
That worked perfect.
Thank you so much Phuocam and ChemistB for the help. You are the best and this site is awsome!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks