[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Hlookup in reverse

Posted on 2011-03-24
Medium Priority
942 Views
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
Question by:aasikolo
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 2

LVL 6

Expert Comment

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

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

LVL 81

Accepted Solution

byundt earned 2000 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

ID: 35206943
Thank you.
0

## Featured Post

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month13 days, 21 hours left to enroll

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

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