G
Guest
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!
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!