I don't have much experience using Hlookup, and maybe there is a better way to go. I have a table that I would like to essentially perform an Hlookup funtion in reverse. In the attached file, the user would enter the air temperature in cell C2, then the maximum number of occupants from row c11:AC11 would be returned in cell C4.
this would be accomplished by comparing values in cells B11:AC32 to the 95 maximum in cell C3, for the air temperature in Cell C2 compared to the values in column B12:B32.
The goal is to determine the maximum number of occupents for a specified confined space that hs a determined hea dissipation rate, based upon outside air temeprature and number of occupants.
I appreciate any guidance you can provide.