Anyone good with excel and if , vlookup and hlookup?

[CoolTech]

=IF(B3<=50,HLOOKUP(B3,coldchart,VLOOKUP(D3,Tables!$M$5:$N$13,2)))

=IF(B3>=67,HLOOKUP(B3,heatstress,VLOOKUP(C3,Tables!$M$26:$N$33,2)))

How do I combine these two if statements correctly, and add a false condition to just show B3 if the temperature thats looked up is out of range, the number 65 is out of range on my chart so if it was in B3, it would just get printed. But, if it were like -25, it would use the hlookup to find the corresponding row of the wind speed and find the windchill, likewise for heat index.

here is an if statement I am trying to use for a few charts I made, the first statement works, but the second one doesnt. Is the syntax correct for implementing both statements? It looks up a temperature and whether or not its a certain range it will look into either a cold or a hot chart of temperatures and return a value for either heat index or wind chill.

How do I get these

 

[Ryan]

I guess, why?

Edit: Hmm, not that good.

 

[CoolTech]

sorry, it posted so fast, I hit enter without placing any text there

 

[SilentRunning]

Originally posted by: CoolTech
=IF(B13>=67,HLOOKUP(B13,heatstress,VLOOKUP(C13,Tables!$M$26:$N$33,2,IF(B33<=50,HLOOKUP(B13,coldchart,VLOOKUP(D13,Tables!$M$5:$N$13,2))))))

here is an if statement I am trying to use for a few charts I made, the first statement works, but the second one doesnt. Is the syntax correct for implementing both statements? It looks up a temperature and whether or not its a certain range it will look into either a cold or a hot chart of temperatures and return a value for either heat index or wind chill.

Don't know much about them but in the second if statement you reference B33 instead of B13

 

[KMurphy]

http://www.decisionmodels.com/optspeede.htm#Options

You would probably have more luck using a combination of INDEX and MATCH using a "stored results" column for retrieved data. That page has some good tips. There is more than one way to accomplish your task so play around. If you don't figure it out, send me your excel file (no macros) and I'll take a look. I'm not a pro; just did a similar workseet last week looking up fuse and current values to yield interrupting times based on fuse type and size.

 

[CoolTech]

help!!