Taking data from other sheets with line and column intersection

[Abdullahorhn]

ı am working on excel with stock market and ı made an excel and ı write stocks code to A1 cell and when ı write it, excel takes data from stock's sheet. My question is: For example if ı write A1 cell EGEEN and B1 cell 2017/3, ı want to take 2017/3's datas to b1 column. I am learning excel new and ı hope you understand what i mean, my english is not well

My excel link

https://drive.google.com/open?id=10Z5ZDGU6Le3D3yjxtEE_rwPvASYQi9ef

 

[Abdullahorhn]

help