Let column A is the Range of the Data
Column B is the lookup value.
I want to find if column B value in the column A range.
COLUMN C IS THE RESULT. HOW TO SET UP FORMULA IN COL C??
EG
A-------B--------C
123---245-----FALSE
456---333-----TRUE
789---135-----FALSE
111---456-----TRUE
222
333
excel, 確定是否符合 內容範圍公式
2011-07-17 12:36 am
回答 (2)
2011-07-17 8:00 am
✔ 最佳答案
此題, 用countif 或 match均可=COUNTIF(A:A,B1)>0
=ISNUMBER(MATCH(B1,A:A,0))
=COUNT(MATCH(B1,A:A,0))>0
=AND(COUNTIF(A:A,B1))
=OR(COUNTIF(A:A,B1))
=NOT(COUNTIF(A:A,B1)=0)
2011-07-17 1:58 am
C1=IF(COUNTIF(A:A,B1)>0,"True","False")
Please try
Please try
收錄日期: 2021-04-23 23:31:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110716000051KK00620