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
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
Bookmarks