Hi,
I have a number of worksheets in a workbook from which I extract data using lookup-type formulae to a single “Data” worksheet in the same workbook.
The data in the “Data” worksheet is arranged in a conventional form, with column A containing Product Name, column B showing Sales, column C has Profit etc.
Rather than hard-coding the lookup functions’ arguments (e.g. col_index_num in VLOOKUP) into the formulae, I’ve put them in the rows, around 25 in all, above the table and reference them.
From a “best practice” point of view would it be better instead to place the formulae arguments in columns, as part of the data table? Then the first row in the Data worksheet would contain the column headings; or does this not matter?
Thanks!
I have a number of worksheets in a workbook from which I extract data using lookup-type formulae to a single “Data” worksheet in the same workbook.
The data in the “Data” worksheet is arranged in a conventional form, with column A containing Product Name, column B showing Sales, column C has Profit etc.
Rather than hard-coding the lookup functions’ arguments (e.g. col_index_num in VLOOKUP) into the formulae, I’ve put them in the rows, around 25 in all, above the table and reference them.
From a “best practice” point of view would it be better instead to place the formulae arguments in columns, as part of the data table? Then the first row in the Data worksheet would contain the column headings; or does this not matter?
Thanks!
