Nov 16 2022 01:12 PM
I am currently working on a dynamic calculation of values based on what is typed into a cell on a different sheet inside of a work book. I have tried everything from different lookup functions to match and index, and I am stuck.
The process goes as follows, on 'TableLinksB36!' a value will be entered that represents the roof top temperature of a home at 0.5" above the roof, then on Lists there is a table that references the value from TableLinks! goes to that row in the table, and then checks for another value at 'TableLinksB36!' which is referring to one of the headers from the temperature table on Lists!, once the formula determines both of those values, it will match up the row(roof top temp) and column(table header) and return the value that matches both criteria.
Attached below is the two sheets that are referenced. Any help would be appreciated. Thank you
Nov 16 2022 01:20 PM
SolutionNov 16 2022 01:20 PM
Solution