IF, AND, HLOOKUP

[Thweed]

Using MS Office (Student Version) 2004 on an Imac Intel Duo Version
10.4.9

I'm a novice and need a bit of assistance.
I've set up Table_One containing $ and ç using cells C1:E10
I have a $ and ç value in cell A1
I would like a formula for Cell B1 that does the following:
Checks for the values in Column C that are Greater Than or Equal
To Cell A1
and
Checks for the values in Column D that are Less Than or Equal to
Cell A1
and then
provide the Value from Column E in that Row

 

[Bob Greenblatt]

Using MS Office (Student Version) 2004 on an Imac Intel Duo Version
10.4.9

I'm a novice and need a bit of assistance.
I've set up Table_One containing $ and ç using cells C1:E10
I have a $ and ç value in cell A1
I would like a formula for Cell B1 that does the following:
Checks for the values in Column C that are Greater Than or Equal
To Cell A1
and
Checks for the values in Column D that are Less Than or Equal to
Cell A1
and then
provide the Value from Column E in that Row

It's unclear what you are asking for. Do you want a formula in each row to
check the entire table column? If so you'll need an array formula. Try to
explain a little clearer what you are trying to do. If you simply want the
value from column E in that row if c is greater than a and d is less than A
try the following:

=if(and(c1>a1,d1<a1),e1,"")