Looking for matching info in Excel

Microsoft Excel 2003 (full product)
January 8, 2010 at 09:38:43
Specs: Windows XP
If I have a whole bunch of info (approx. 300 rows) under Col. A. And I would like to paste some cells of data into Col. B and looking for possible match with the data in Col. A. I'd like to see a "Y" under Col. C in the cell adjacent to a match and show nothing when there's no match. ???? TIA.

A B C
t039r02w4 t039r03w4 Y
t039r03w4 t049r03w4
t049r01w4 t050r01w4 Y
t049r02w4 t050r02w4 Y
t050r01w4 t050r04w4
t050r02w4 t050r06w4
t050r03w4 t063r02w4 Y
t062r02w4
t063r02w4
t063r03w4


See More: Looking for matching info in Excel

Report •


#1
January 8, 2010 at 09:51:01
Try this in C1 and copy down

=IF(ISERROR(MATCH(B1,$A$1:$A$100,0)),"","Y")

I've set it for 100 cells in column A

MIKE

http://www.skeptic.com/


Report •

#2
January 8, 2010 at 10:03:29
Hi Mike,

Thanks for your help. That's exactly what I'm looking for. I thought of using something like MATCH, VLOOKUP etc. But I'm not sure how to set them up. Anyway thanks again and have a nice day.


Report •

#3
January 8, 2010 at 10:12:08
Glad I could help.
Also, just so you know there is a Conditional Formatting solution to your problem that will highlight the matching/non matching numbers.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question