If Formula (multiconditon) Auto Generate When add a value

hello evryone

1 = I have a range of (G10:G1500). In this range i add data in number like(50 to 450)..
2 = In range (I10:I1500) I have words like (BC, J, JT, VC)
3 = In range (R10:R1500) i want the result according the below condition


Condition 1 = If Cell (I10) = (HB)
and
Cell (G10) = (178 to 500) Number
then want answer in cell (R10) result 1= "HBC"

and
Cell (G10) = (158 to 177) Number
then want answer in cell (R10) result 2= "LBC"

and
Cell (G10) = (100 to 157) Number
then want answer in cell (R10) result 3= "HBC"

and
Cell (G10) = (50 to 99) Number
thenwant answer in cell (R10) result 3= "VC"


And other words (J, JT, VC) have above same condition

e.g if Cell I10 = JT then RESULT 1 = HJT, RESULT 2 = LJT, RESULT 3 = SLJT

e.g if Cell I10 = J then RESULT 1 = HT, RESULT 2 = LT, RESULT 3 = SLJ

and formula auto generate according to cell range(G10:G1500)
i mean if i type in Cell "G11" then result according to Cell "I11" should be in Cell "R11" and continue....
thanx a lot

I use this formula in excel

Please Login or Register  to view this content.

Y3 = number what ever i want
Y5 = number what ever i want
Y4 = number what ever i want

AA3 = number what ever i want
AA5 = number what ever i want
AA4 = number what ever i want

AC3 = number what ever i want
AC5 = number what ever i want
AC4 = number what ever i want