Lookup to return multiple values

[cispus78]

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

[Ron Coderre]

Sheet2, A1:B20 contains this list

Category	Amount
NotLand	999
NotLand	999
Land	1
NotLand	999
NotLand	999
Land	10
NotLand	999
NotLand	999
NotLand	999
Land	100
NotLand	999
NotLand	999
NotLand	999
NotLand	999
Land	1000
NotLand	999
NotLand	999
NotLand	999
NotLand	999

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

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

B5: =SUMIF(Sheet2!A2:A20,A5,Sheet2!B2:B20)

In the above example, B5 returns: 1,111

Is that something you can work with?

[cispus78]

This works perfectly!!

Cheers!