Trying to lookup multiple entries in very large column using Vlookup

[Trogmorison]

Hi, if anyone could help with a formula it would be greatly appreciated.
I need to extract data from a huge list of English words onto a smaller list of words.
The problem I have is that many of the words appear more than once on the big list with different attributes. For example, the word "still" appears four times as an adjective, a noun, a verb and an adverb. I need to be able to extract the data for each instance the words appear. Most appear once, many twice and a few three or more times.
I have a workbook with two sheets in. In the first sheet I have 60024 rows of data. Column A is the words and the other columns are the associated data. In the second sheet I have 3357 rows. Column A is the words, the next column is the word frequency and the final column is the word type. The problem I have with using Vlookup is that it only returns the first result of the words in the big list.

[Glenn Kennedy]

Something like this, maybe (array formula, entered with CTRL + SHIFT + ENTER). Not sure how it will react to a HUGE sheet, though!

[cbatrody]

Hi,

Pivot Table would be an easier option. Otherwise you may have to use an array formula.

http://office.microsoft.com/en-us/ex...001226038.aspx

[Glenn Kennedy]

Go with that one first. Try the Pivot Table... likely to be quicker...