Hi!

Try this:

Transaction type in column B, amount to return in column C:

=LOOKUP(2,1/(B1:B20="buy"),C1:C20)

Biff

"K.L. Smith" wrote in message
...
The scenario:
I have a spreadsheet to track my stocks. Each stock has its own worksheet
with the stock symbol as the worksheet name (ie IBM). I also have a
worksheet that summarizes all the individual sheets. On the individual
stock
sheets there is a column (B) for the transaction type (buy sell dividend
split etc) and a column (C) for the amount.
Now for my problem:
I want to be able to list on the summary sheet the last amount received
for
each transaction type for each stock. I have tried various LOOKUP
functions
and the OFFSET function, but I always just come up with the last value in
the
column, not the last value for a particular transaction type.

I am new to the forum so any and all help would be appreciated.