NL Table Nested If Calculation

Hi All,

I have a NL Table statement that brings back data from the G/L Entry Table. I need to "Parse" the Description field to extract the Vendor number or document number depending on the Description, so for example, when it is a Direct Cost Posting, I want to remove the Vendor number…. This NP statement works for One if statement, I need to nest them like the second example.

This NP works:
=NP("formula","=IF([Qualifier1]=$C$2,mid([Description],13,6),$C$5)") So if the Qualifier1 column = C2, extract the 6 character Vendor number from the Description .. if false, = C5

I need something more like:

=NP("formula","=IF([Qualifier1]=$C$2,mid([Description],13,6),IF([Qualifier1]=$C$3,mid([Description],15,6),IF([Qualifier1]=$C$4,mid([Description],13,6),$C$5)") The location of the data in the description field moves depending on the description.

There might be a smarter way to do this…. I consider myself a novice at this and would be happy to consider any other way to accomplish this.

Thanks,