Hi
The formulas that can help you are VLOOKUP and MATCH. VLOOKUP is probably quite suitable, with some reservations - your large list needs to be sorted into sequential order (numeric or alphabetical) as the formula searches down the list from top to bottom trying to find a match.
Say your small list has names in A1:A10
Say your big list (array) has names in D1:D100 and data in E1:E100.
To find the data for your name in A1, type this formula in B1 =VLOOKUP(A1,$D$1:$E$100,2,FALSE). You can then scroll this formula down column B.
The array D1:E100 has $ signs to fix the columns and rows so that they do not change when you scroll the formula down.
The 2 in the formula refers to the 2nd column of your array (the column with the data you want to pick up)
If you do not add the "False" this formula is likely to give you the nearest answer if there is no exact match. Adding "False" to the formula makes it return an error value if the name you are searching for is not in the list.
Look in the help section for more examples.
Hope this helps
Regards
Derek
