[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 990
  • Last Modified:

Hlookup in reverse

Hello,

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
0
aasikolo
Asked:
aasikolo
  • 2
1 Solution
 
FernandoFernandesCommented:
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 ?
0
 
FernandoFernandesCommented:
and should the temperature on C3 affect in anyway your expected result ?
0
 
byundtCommented:
Try a formula like this:
=LOOKUP(C3,INDEX(C12:AC32,MATCH(C2,B12:B32,0),),C11:AC11)
0
 
aasikoloAuthor Commented:
Thank you.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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