Is it Possible to make Custom formula using this long formula

[AnamKhan]

hi,
i have a formula, which one i am using to get result.
this formula is long and taking too much space,

is it possible to make a custom fucntion using vba

the formula is

=IF(I10="LBC",IF(X10>$Y$3,"HB",IF(X10>$Y$5,"LB",IF(X10>$Y$4,"SLB","ESLB"))),IF(I10="JT",IF(X10>$AA$3,"HJT",IF(X10>$AA$5,"LJT",IF(X10>$AA$4,"SLJT","ESLJT"))),IF(I10="J",IF(X10>$AC$3,"HJ",IF(X10>$AC$5,"LJ",IF(X10>$AC$4,"SLJ","ESLJ"))))))

sample.JPG

Thanx

[davesexcel]

You could build a table, then use vlookup to find I10 and X10.

[AnamKhan]

Thanx for the reply @davesexcel Sir

but i don't know much about table or pivot table

because i use to VBA and i feel comfortable to use vba