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

Please Login or Register  to view this content.

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