Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I match numbers from two columns?
I have two columns with numbers. Some numbers are in both columns, some not.
What I need to get is some formula that can compare both columns and tell me wich numbers are already in column 1 and what numbers are not. Something like this: 234 222 It's not in column A 444 300 Yes, it's in column A 300 150 It's not in column A I'll appreciate any help! |
#2
|
|||
|
|||
One way assuming the list you want to check is in column B starting in
row 1, in C1 enter the formula: =IF(ISNA(VLOOKUP(B1,A:A,1,0)),"It's not in Column A","Yes, it's in column A") and copy down. Hope this helps Rowan Lea wrote: I have two columns with numbers. Some numbers are in both columns, some not. What I need to get is some formula that can compare both columns and tell me wich numbers are already in column 1 and what numbers are not. Something like this: 234 222 It's not in column A 444 300 Yes, it's in column A 300 150 It's not in column A I'll appreciate any help! |
#3
|
|||
|
|||
Hello Lea
=IF(NOT(ISERROR(MATCH(B1,$A$1:$A$8,0))),"Yes it's in column A","it's not in column A") Please amend accordingly (only values in A1 through A8 tested here) HTH Cordially Pascal "Lea" <Lea @discussions.microsoft.com a écrit dans le message de news: ... I have two columns with numbers. Some numbers are in both columns, some not. What I need to get is some formula that can compare both columns and tell me wich numbers are already in column 1 and what numbers are not. Something like this: 234 222 It's not in column A 444 300 Yes, it's in column A 300 150 It's not in column A I'll appreciate any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find MATCH numbers ? | Excel Worksheet Functions | |||
how can I omit the array( numbers and letters for columns and row | New Users to Excel | |||
column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |