Need Help in Ms-Excel

S

smarttrade

Active Member
#1
#1
Dear All,

I have Copied Bhav Copy Datas (Date,Open,High,Low,Close) in Sheet1 and additionally added one more column of Number in F column.
My query is If I enter the Number in D3 Cell of Sheet2 then that number should search in sheet1 (F Column) and display corresponding previous 5 days Data in Sheet2 (A7 to E12 Cell) .

Example :
If I enter Number 6 in D3 Cell (Sheet2) then first search this 6 in F Column (Sheet1) . 07-Mar-12 data is 6 . So i want to display data from 01-mar-12 to 06-mar-12 in A7 to E12 Cell (sheet2) .

I have Attached this Excel Image File Here. Kindly Help Me. Thanks in Advance.
 

Attachments

gambler

gambler

Well-Known Member
#2
#2
smarttrade said:
Dear All,

I have Copied Bhav Copy Datas (Date,Open,High,Low,Close) in Sheet1 and additionally added one more column of Number in F column.
My query is If I enter the Number in D3 Cell of Sheet2 then that number should search in sheet1 (F Column) and display corresponding previous 5 days Data in Sheet2 (A7 to E12 Cell) .

Example :
If I enter Number 6 in D3 Cell (Sheet2) then first search this 6 in F Column (Sheet1) . 07-Mar-12 data is 6 . So i want to display data from 01-mar-12 to 06-mar-12 in A7 to E12 Cell (sheet2) .

I have Attached this Excel Image File Here. Kindly Help Me. Thanks in Advance.
Click to expand...
It can be done with vlookup function.
 
P

prabhsingh

Well-Known Member
#7
#7
Hi Gambler,

Which property is controlling refresh of data in this excel sheet.What i mean is when we press enter on D3 cell,data automatically gets refresh.Which property is controlling this execution?
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
M Need help to export hourly data to excel AmiBroker 0
guptak03 Help needed in excel. Software 0
W Help Needed/ Protofolio management Excel Beginners Guide 0
E Help needed in Excel Software 7
A Need help to create my swing trading excel to afl. AmiBroker 2

Similar threads