Stock Portfolio Formula

I am trying to Track my stocks in Excel. Below is the formula that I am using to locate the info. This forumla works in the Google Spread Sheets, but not when I copy and paste it to Excel 2010.

=iferror(if(row()<>2,INDEX(arrayformula(filter($I14:$I$2,$C14:$C$2<>ʺʺ,row($C14:$C$2)=max(if($C14:$C$2=C15,row($C14:$C$2),0)))) ;1),0),0)

I have attached the spread sheet that I am working on. Basically, I want a cell to reference the other cells above it in the spread sheet, and look for a criteria, like a Stock symbol. If it finds that Criteria or Stock Symbol, I need it to grab some information from that line. Oh by the way, there could be multiple lines with that stock symbol, so I need it to reference the last line. Any help would be great appreciated.

Thanks,

DiliPandy,

Here are the new sheets with the formulas and numbers that should be in the cells. The formulas work in Google docs, but not in excel.

Thanks,

Kevin

HI DiliPandey,

I'm sorry for all the confusion, I'm really not trying to be hard, lol. I have fixed the spreadsheet and highlighted the columns. I added some arrows showing you the flow.

Thanks,

Kevin

DiliPandy,

There is relevance in Row B. Yes exactly, it along with Column C help the equation find the information above. As for:
By following your flow, H12 and H13 should be 165.563, please check.
H10 shows the units that were bought in cell I9. The units in H10 and H11 don't change, because the relationship of the dividend. H11 shares are added to the D11 shares and summed up in I11. The same applies to J14 and K15. The transacted value isn't added to the cost because it is a dividend. The dividend only adds money to the cumulative cost and Gains/Losses.

Thanks,

Kevin