Hi All,
column C is from 1 to 12
column D is an amount
I have a table of numbers which categorized the numbers with specified amount and categorized person (column H, K & L)
EX: If (1) with a range of amount from ( 0 to 13,000) it will be with Senior 1
if (1) with a range of amount from ( 0 to 19,000) it will be with Senior 2
so, I have this table with 12 numbers and each number contain 9 ranges of amounts with difference names
can anyone help with an equation that can lookup column C and D with K and L to find the name in column H