Previous Topic Next Topic

Any one can help.

Closed
mekko Posts 2 Registration date Monday May 8, 2017 Status Member Last seen May 8, 2017 - May 8, 2017 at 05:15 AM
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