Hello! Everyone,

Data.png

as per the attachment, I want to separate date on another sheet.

For Example in sheet A, I have the above data.

now I am using vlookup formula but it is not working. Looking value "bnk-129" and want to separate time looking up an open value of bnk-129.

(Sorry For English)