Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the matching value from a list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the matching value from a list
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Lists Where List Size is Unequal | Excel Discussion (Misc queries) | |||
Copy # fm one list to matching id in list 2? | Excel Worksheet Functions | |||
find sum in list of of numbers | New Users to Excel | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions |