hi, maybe this link will help you

http://www.j-walk.com/ss/excel/usertips/tip073.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"iamjbunni" escreveu:

I have a list of numbers and I need to match the number with the rest of the
information. For example:

123 891
651 456
456 789
789 421
320

I need a formula that will find the matching number and place in the column
next to it, or highlight the position of the matching number:


123 891
651 456 456
456 789 789
789 421
320
123 123