in the attached workbook there are a few different sheets, the first sheet is consolidation of all of the other sheets.
Some columns are missing from the sheets which feed into the consolidation sheets and some rows are too.
I am trying to build a function that I will use on the summary sheet to link to the correct cells on the other sheets.
eg. the function is to use sheets name contained in column A, and then generates a row number by matching the row that the item is on, and a column number by matching the header name, that the information is in, the function will return the value that is in the target cell.
if either the sheet, row or column are missing, I would like the function to return "S", "R" or "C" to identify which piece of information is missing. if there is no slave sheet with the same name the function should only return "S"
I was thinking that an offset from Cell A1 on each sheet would be able to generate the range that the information is in, if it is there, and return the value of what ever is in that cell.
Some columns are missing from the sheets which feed into the consolidation sheets and some rows are too.
I am trying to build a function that I will use on the summary sheet to link to the correct cells on the other sheets.
eg. the function is to use sheets name contained in column A, and then generates a row number by matching the row that the item is on, and a column number by matching the header name, that the information is in, the function will return the value that is in the target cell.
if either the sheet, row or column are missing, I would like the function to return "S", "R" or "C" to identify which piece of information is missing. if there is no slave sheet with the same name the function should only return "S"
I was thinking that an offset from Cell A1 on each sheet would be able to generate the range that the information is in, if it is there, and return the value of what ever is in that cell.