I have attached the relevant sample w/s.
I have a series of vertical, 2-columned tables. Each table represents an Equity Name, for which the date and the corresponding price are given in the columns.
What I want to do is in a seperate cell, by specifying a random Equity Name and a date, the function to retreive the correct price. I have managed to do this in the past, but I have been trying for the past 2 weeks with poor results. If my memory serves me right, I had used, lookup, match, offset, index.
I would be so grateful if somebody could help me here please..