• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If conditions based on accounts head

Shabbo

Member
Dear Sir,

I wanted to customize my import sheet like this.

If X column has mentioned ExpsFuel then J column should show as TRIPEXP my K column should show as S2 and my column L should show as Voucher number from 181901829 from Column F.

If X column has NOT mentioned ExpsFuel then J column should show as Billing my N column should show as P3 and my column O should show as Voucher number from 181901830from Column F.
 

Attachments

  • ENTRY NUMBER FOR BILLING AND TRIPEXPS.xls
    17 KB · Views: 9
Hi,

Try a combination of if, not and count. If you want specific formulas for each column do let me know. I ll then post the exact formulas.
Thanks
 
Back
Top