英文:
Lookup and see two different cell and then copy
问题
我的查询是：
我需要一个宏，用于
IF A9 = "GBP" AND B9 = "GERMANY- ABS" AND NEW CELL = GERMANY
问题是B9不是精确的"GERMANY"，它包含一些其他文本，所以我们应该使用LIKE函数。
你能帮忙吗？
我有上面问题的宏或公式。
英文:
My query is:
I need a macro for
IF A9 = "GBP" AND B9 = "GERMANY- ABS" AND NEW CELL = GERMANY
The problem is B9 is not exact "GERMANY", it contains some other text so we should use LIKE function.
Can you please help?
i have macro or formula for above issue
答案1
得分: 1
在Excel中，您可以使用FIND或SEARCH，它类似于LIKE。这里举例说明了两个IF条件，其中一个是查找单元格中的"GERMANY"，根据您的需求修改示例：
=IF(AND(A1="GBP",IFERROR(FIND("GERMANY",B1), 0) > 0),TRUE,FALSE)
英文:
In Excel you can use FIND or SEARCH it's similar to LIKE. Here for example you have two IF conditions, where one of them is to find "GERMANY" in cell, modify example according to your needs:
=IF(AND(A1="GBP",IFERROR(FIND("GERMANY",B1), 0) > 0),TRUE,FALSE)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论