如何检查某列中是否存在某些票证? [英] How can I check if a certain ticket # is present in a column?

问题描述

我正在尝试创建一个电子表格，以显示某些装运的零件是否已经到货，但是我被困在IF声明中.基本上，我希望它检查列中是否存在特定的票号，因为每张票都有唯一的ID.

我当前的代码:

  = IF(REGEXMATCH(E2，'出货清单响应'！D:D)，是"，否") 

我希望它检查当前工作表的1个单元格中的数据是否在另一工作表的D列中.但是，该薄片是空的，并且正在输出是".请帮忙吗?

解决方案

您可以使用此公式来实现您想要做的事情:

= if(countif('发货清单响应'！D:D，E2)，是"，否")

如果您想将其用于arrayformula而不是单元格 E2 ，则只能在整列 E 中进行搜索，则可以使用以下公式:/p>

= ArrayFormula(if(len(E2:E)，if(countif('船运库存响应'！D:D，E2:E)，是"，否")，))

I am trying to create a spreadsheet that shows if certain shipments of parts have arrived yet, but I am stuck on the IF Statement. Basically, I want it to check if a certain ticket number is present in the column as each ticket has a unique ID.

My current code:

=IF(REGEXMATCH(E2, 'Shipment Inventory Responses'!D:D), "Yes", "No")

I want it do check if the data in 1 cell on the current sheet is present in the D column of another sheet. However, The sheet is empty and it is outputting "Yes". Please help?

解决方案

You can use this formula to achieve what you want to do:

=if(countif('Shipment Inventory Responses'!D:D, E2),"Yes","No")

if you want to use it with an arrayformula for instead of the cell E2 only you could search in the whole column E, you can have the following formula:

=ArrayFormula(if(len(E2:E),if(countif('Shipment Inventory Responses'!D:D,E2:E),"Yes","No"),))

这篇关于如何检查某列中是否存在某些票证?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！