

 Thread Tools  Search this Thread 
#1
 
 
How to check if a number belongs to a column or not in Excel I am on Excel. I would just like a formula that might check if a number belongs to a column or not. Style: = IF (A1 "is in column B," "YES"; "NO") The question is: how to translate "belongs to in column B"? 
#2
 
 
Re: How to check if a number belongs to a column or not in Excel Good evening = if (Column (A1) = 2; "Column B", "No column B") <( is necessarily the "No column B"... The function column relates to column number and not the index "B" To find "B" share a table with a match I can not tell you. Best regards 
#3
 
 
Re: How to check if a number belongs to a column or not in Excel Hmmm ... I think it does not help me at all. What is it a match? 
#4
 
 
Re: How to check if a number belongs to a column or not in Excel It can not help you at all, yet that is exactly what you require. So may be more accurate ... Because A1, before the cell is in column B, it will rain in a rainstorm ... As = IF (A1 "is in column B," "YES"; "NO") and = if (Column (A1) = 2; "Column B", "No column B") that's exactly what you want ... 
#5
 
 
Re: How to check if a number belongs to a column or not in Excel When you speak of A1 is a value to search, or it represents cell A1? A value, I suppose, since you are looking for a value in column B. What I want to do everything really does seem silly. Let's say in column A, I have the following values: 1 2 3 4 5 6 7 8 9 10 And in column B, I: 3 4 6 8 9 The result in column C would be: NO NO YES YES NO YES NO YES YES In column C, for each line in column A, I would like to display "YES" if Ax is also in column B, and "NO" otherwise. 

Tags: excel 
Thread Tools  Search this Thread 

Similar Threads for: "How to check if a number belongs to a column or not in Excel"  
Thread  Thread Starter  Forum  Replies  Last Post 
What is the way to sum up number of column in Pivot Table  Dvimida  MS Office Support  2  09022012 07:31 PM 
Sort a row or column in MS Excel  Itronix  Tips & Tweaks  1  15062011 09:52 AM 
How to find particular column name by using Excel Macro  Eleder  Windows Software  5  05042011 10:49 PM 
How to count number of text occurences in Excel column  Anas  Windows Software  3  09062009 05:01 PM 
How to reverse column in excel  Vishant  Windows Software  2  09062009 01:53 PM 