If I try
A1 is the stock code and
A2 is the date I'm querying, it comes back printing 'date' and 'volume' on one line as headers and then the data on the line below. Is there a way to have this formula printing on each line without the headers?
A1 13/06/20 B1 daily volume A2 12/06/20 B2 daily volume A3 11/06/20 B3 daily volume
I'm just trying to build the formula that can give the data for B1,B2,B3 etc and drag it down so the data is on each line querying the respective date in column A.
What formula do I need to use?