Find the matching value from a list

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top