Solved

Hlookup in reverse

Posted on 2011-03-24
4
744 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 80

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

760 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

23 Experts available now in Live!

Get 1:1 Help Now