Find a cell in one file.sheet and bring it into another file.sheet

[fred3]

I have a summary file/sheet and want to bring values from other files into it. There are a few cases:
1) Where the source cell is known. This is easy.
2) Where the source cell is not known but must be found. This is harder and I'd appreciate some help with it.
Example:
One source column has various text entries BUY, SELL, HOLD
Another source column has various numerical entries.
I want to find the LAST entry in the first column that says BUY and I want to transfer the value in the same row from the numerical entries.
Like this:

Price Indicator
3.500 HOLD
3.700 HOLD
3.780 BUY
3.900 HOLD
4.100 HOLD

For this, it would return 3.780.
Then I want to do the same for SELL in the "Indicator" column and figure it must be about the same.

Perhaps easier, I also want to transfer the *last* value in a known column.

[hemesh]

Assuming your Indicator column is Column A and Column with Numbers is column B
in D1 type Sell, E1 Type Buy and In F1 type Hold then in D2 copy paste below and hit enter drag to right
=LOOKUP(2,1/($A$1:$A$1000=D$1),$B$1:$B$1000)

change the references as per data !