Pulling out the latest data with date from the database given.

Hi Guys, i am new to this forum, and can use Excel, but i am not advanced enough to achieve the outcome i want. I have a pretty complex task to process and have got so far but cannot progress.

What I Want

Details of the data required given, Sheet NSE and BSE are the source data and Sheet Output is the sheet where i need data.

Last Traded Price : pull latest last traded price from NSE or BSE tabs. Example : if a "ISIN No" is traded on 1 st Nov 2012 in BSE sheet and 2 nd Nov 12 in NSE sheet, the 2nd Nov price should be in the cell. AND IF BOTH SHEET CONTAINS LATEST DATE PRICE THEN WE SHOULD TAKE NSE PRICE.

Last Price Date : pull out the date whose price is there in last traded price, which is the latest of NSE and BSE sheets.
Last Traded Exchange if the ISIN present on both the sheets for the latest day then output should be "BOTH" where as if latest date on NSE sheet then output NSE else BSE.

Market Cap: pull latest market cap from NSE or BSE tabs. Example : if a "ISIN No" is traded on 1 st Nov 2012 in BSE sheet and 2 nd Nov 12 in NSE sheet, the 2nd Nov Market cap should be in the cell. AND IF BOTH SHEET CONTAINS LATEST DATE MARKET CAP THEN WE SHOULD TAKE NSE MARKET CAP.
ISIN No : lookup value or the key cell which is present on all sheets.

PS : File attached.

hi,

try this..

Copy of Price%20Lookup%20Logic(1).xlsx

thanks for the effort sid, the values are not coming correct. attached file.

hi,

try this... for the dates, paste special, and then text to columns to DMY format...

Copy%20of%20Price%20Lookup%20Logic%281%29(1).xlsx

djwaz69,

I was able to solve your issue... I hope.

Let me know if this is what you were looking for!

P.S. You will have to retype your dates in column G starting around row 1700 on the NSE tab and around row 3800 on the BSE tab because they are only in a text format and are not recognized by the =DAYS360 formula I used to calculate the most current information.


Simeon

Thanks Simeon for the effort, updated values are not correct, request you to kindly recheck the formula, i suppose it would be better of you use index match with given logic or may be with countif logic.

Hi Simeon

Please find the attached file with dates excel date format.

thanks sidd

thanks Brendan, it solved my problem, but is it possible without pulling our dates in column C and D.
I was wondering if its possible with lesser formula because there are other workings too and file size will become heavier. just a request if its possible please help.