| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare data in two columns
What is the correct formula to use to compare data in column A to see if
there is a match in column B. In column C, just return the value in column A if there is a match anywhere in column B, otherwise leave blank. Col A Col B Col C 1234 5555 4321 3457 5555 3241 5555 5241 2319 3457 5361 3457 I have tried Vlookup, If statements, and a few others, but can't seems to get the correct format. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare data in two columns
=IF(COUNTIF($B$1:$B$5,A1),A1,"")
"Kim" wrote: What is the correct formula to use to compare data in column A to see if there is a match in column B. In column C, just return the value in column A if there is a match anywhere in column B, otherwise leave blank. Col A Col B Col C 1234 5555 4321 3457 5555 3241 5555 5241 2319 3457 5361 3457 I have tried Vlookup, If statements, and a few others, but can't seems to get the correct format. Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare data in two columns
Thank you, teethless, it worked!
"Teethless mama" wrote: =IF(COUNTIF($B$1:$B$5,A1),A1,"") "Kim" wrote: What is the correct formula to use to compare data in column A to see if there is a match in column B. In column C, just return the value in column A if there is a match anywhere in column B, otherwise leave blank. Col A Col B Col C 1234 5555 4321 3457 5555 3241 5555 5241 2319 3457 5361 3457 I have tried Vlookup, If statements, and a few others, but can't seems to get the correct format. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare data in two columns | Excel Worksheet Functions | |||
| compare data from 2 columns | Excel Worksheet Functions | |||
| Need to compare data in 2 columns and not sure how. | Charts and Charting in Excel | |||
| Macro to compare two columns of data | Excel Discussion (Misc queries) | |||
| Trying to compare data in two columns... | Excel Worksheet Functions | |||
Linear Mode
