I am trying to create a formula using a table. Using the information below,
I want to find if A1 is greater than or equal to B1 and less than or equal to
C1, use D1.

A B C D
15450 (1) 15001 16000 700
(2) 16001 17000 750
(3) 17001 18000 800

The table is on another tab, but I know how to select those cells. I don't
know how to combine using both columns B and C. To make it trickier, the
table has about 40 rows that need to be in the formula. I kind of remember
doing something like this a long time ago using a conditional table, but I
can't remember what it's called.

Any help would be greatly appreciated!

=IF(AND(A1=B1,A1<=C1),D1,"do something else")

--
Regards,

Peo Sjoblom

(No private emails please)


"Wendy - Payroll" wrote in message
...
I am trying to create a formula using a table. Using the information
below,
I want to find if A1 is greater than or equal to B1 and less than or equal
to
C1, use D1.

A B C D
15450 (1) 15001 16000 700
(2) 16001 17000 750
(3) 17001 18000 800

The table is on another tab, but I know how to select those cells. I
don't
know how to combine using both columns B and C. To make it trickier, the
table has about 40 rows that need to be in the formula. I kind of
remember
doing something like this a long time ago using a conditional table, but I
can't remember what it's called.

Any help would be greatly appreciated!