matching a list of values in a large data set

[cheesymango]

This is my first post so I hope I've done it correctly. Thanks all!


I need to find a value "abc123" in the following data. It's easy to find it for one value where I just go Ctrl + F = "abc123". But I have to find match 10000s of different values like abc123 to see if they exist in an extensive table of data. Is there a formula for this? Much appreciated!!

abc123	def123	bla123	ald321
abc124	def124	bla124	ald322
abc125	def125	bla125	ald323
abc126	def126	bla126	ald324
abc127	def127	bla127	ald325
abc128	def128	bla128	ald326
abc129	def129	bla129	ald327
abc130	def130	bla130	ald328
abc131	def131	bla131	ald329
abc132	def132	bla132	ald330
abc133	def133	bla133	ald331
abc134	def134	bla134	ald332
abc135	def135	bla135	ald333
abc136	def136	bla136	ald334

<tbody>
</tbody>

 

[Snakehips]

cheesy mango,

So similar to this I helped with earlier.

http://www.mrexcel.com/forum/excel-questions/972123-how-lookup-value-across-multiple-columns.html

Am I doing homework ?

 

[cheesymango]

Thanks Snakehips!
Formula works perfectly.

I wish I still had homework :')

Cheers.
J