Hi,
I have a spreasheet that I use to import data from one sheet to another, that could be in any order and organise the results in a logical order.
I am using a Vloopup formula to find single values for example =VLOOKUP($A5&B$4,INDIRECT("'"&$B$2&"'!$A$1:$T$5000"),2,FALSE).
This works fine for single values, but I want to find and export a table of data? Is there a way of finding a varibale in the list and then export data from a specified location to another sheet?
In the simple spreadsheet attached, I want to copy the annual data from 'raw data' and paste into sheet one, but that data could be could start anywhere in column B next to the variable name 'Annual sales'
Thanks for you assistance.
Bookmarks