Remember Me?

#1
April 11th 07, 10:34 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 284
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
April 11th 07, 11:48 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 3,718
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
April 12th 07, 03:14 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 284
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post excellearn2006 Excel Worksheet Functions 2 August 17th 06 11:13 PM micmed Excel Worksheet Functions 3 February 13th 06 02:53 AM Stacey Charts and Charting in Excel 0 February 8th 06 04:47 PM Odawg Excel Discussion (Misc queries) 0 October 12th 05 03:13 AM accessgrits Excel Worksheet Functions 5 May 12th 05 06:32 PM

All times are GMT +1. The time now is 09:38 PM.