I need a cell to be filled with a certain text when two other cells contain a certain value
Y Segal
I tried to use the countif function and then tried using vlookup and was not really successful.
The condition statement I need is, for example, if L10 contains the word "TAX" and M10 contains the word "USA", cell N10 will automatically fill with the word "VAT" in red, if one of them is missing, leave it blank.
Thank you for any help
Engineer Toast
Use the formula below in cell N10 and set the text color to red. Since you want either "VAT" in red or blank, then the blank text can be set to red and it won't matter. No conditional formatting required.
=IF(AND(NOT(ISERROR(SEARCH("tax",L10))),NOT(ISERROR(SEARCH("usa",M10)))),"VAT","")
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
编辑于
相关文章
Related 相关文章
- 1
Multiple Conditional formatting to highlight a third cell when two cells match
- 2
R: Find if value is within a certain percentage of any other value in its row
- 3
mysql select for simple join for rows having certain cells with duplicate values
- 4
Matrix traversal with rules that must hit certain cells. Interview
- 5
How do I print out just certain elements from a text file that has xml tags to a new text file?
- 6
Get a certain value in a JSON string using a regex
- 7
ng-repeat save certain value as cookie
- 8
Not loading a Spring bean when a certain profile is set
- 9
Is it possible to reference two cells in Excel to find a third cell?
- 10
How to count cells in a range with a value less than another cell in excel?
- 11
When a certain item on dropdownlist1 is selected, select automatically a certain item on dropdownlist2
- 12
Display button when hover over certain row in table
- 13
How to change CSS when user scrolls past a certain div
- 14
Skipping certain fields in subdocument when doing a multikey index in MongoDB
- 15
How do I retrieve the text of a cell comment
- 16
Using Nokogiri I am unable to find certain nodes in a document
- 17
Using Gradle, how can I ensure that a file exists at a certain location?
- 18
How can I recursively find the *directories* containing a file of a certain type?
- 19
Need CFReadStream Block untill buffer size in not filled
- 20
Select element with certain style?
- 21
Sort argv in a certain order
- 22
how to change values with rank value (ordered value) in R? and I want to give same numbers when two values tie
- 23
How to pick a random element in an np array only if it isn't a certain value
- 24
DataGridView Event to Catch When Cell Value Has Been Changed by User
- 25
How do I check if a certain User exists under a specific Login in SQL?
- 26
Should I populate model data from a view in certain case - asp.net MVC
- 27
Why can't I return from certain processor exceptions? Toy kernel dev
- 28
Send push with parse to certain device?
- 29
Allow certain style attributes with ngSanitize
我来说两句