Solved

Hlookup in reverse

Posted on 2011-03-24
4
764 Views
Last Modified: 2012-05-11
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
Comment
Question by:aasikolo
  • 2
4 Comments
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35206660
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
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35206715
and should the temperature on C3 affect in anyway your expected result ?
0
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 35206723
Try a formula like this:
=LOOKUP(C3,INDEX(C12:AC32,MATCH(C2,B12:B32,0),),C11:AC11)
0
 

Author Closing Comment

by:aasikolo
ID: 35206943
Thank you.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now