Lookup to return multiple values

Is there a way to use a lookup formula to return all values of a given text, not just the value of the first listing of the text.

In an attempt to clarify my already confusing request, if A5 on "worksheet1" is "Land" I want E5 on "worksheet1" to return the summation of values assigned to "Land" "worksheet2" "column B" any time "Land" appears on "Worksheet2" "Column A". Is this possible?

Cheers,
C

Sheet2, A1:B20 contains this list

Please Login or Register  to view this content.

and...on Sheet1...
A5: Land

This formula returns the sum of Sheet2, Col_B items where the corresponding
Col_A item is "Land"

Please Login or Register  to view this content.

In the above example, B5 returns: 1,111

Is that something you can work with?