• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1054
  • Last Modified:

Hlookup in reverse


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.

Thank you

aasikolo HLookup-example.xls
  • 2
1 Solution
sorry to ask this, but, i think I can help you, i just need an example...
if you put 77 in cell C2, what should be the result ?
and should the temperature on C3 affect in anyway your expected result ?
Try a formula like this:
aasikoloAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now