I have a problem. I have multiple tables and want to find a value. So far easy but my problem is that I have different values (dates in this case) in the columns. See attached picture.
So what I want to do it to find the value of a stock based on the name of the stock and the date. I have tried but just can't seem to find a solution .
This is the sheet I want the values in (it's all in the same file)
And this is the sheet where the values is
So what I want to do it to find the value of a stock based on the name of the stock and the date. I have tried but just can't seem to find a solution .
This is the sheet I want the values in (it's all in the same file)
And this is the sheet where the values is