Sir,
Sub: extract data from one excel worksheet to another worksheet
I have a model excel sheet enclosed. The table has a list of shares and their price range for a single day split into various price levels.
Now I request a formula to do the following;
In answer sheet1, I request that as I enter the level of any share, it should capture the corresponding price relating to that share from sheet 1 as illustrated;
Likewise In answer sheet2, I request that as I enter the any price of any share, it should capture the corresponding level relating to that share from sheet 1 as illustrated;
thanks in advance
vks1964