Dear Sir,
This Formula works fine thanks for the same, just one more thing to be added.
If There is a voucher number in O column and Column C is Vendor then J column should be billing- N column P3- column O Voucher no. and Column P date
If There is a voucher number in O column and If Column C is then Fuel expenses J column should be Tripexp - K column P2- column L Voucher no. and Column L date.
But if there is no Voucher number then Billing and Tripexp both should be blank.
I have attached my excel for your ready reference.
Hi Sarfraz,
Here is a formula you can use in column J, for Billing/Tripexp values:
=IF(AND(O2<>"",ISNUMBER(SEARCH("vendor",C2))),"Billing",IF(AND(O2<>"",ISNUMBER(SEARCH("fuel expense",C2))),"Tripexp",""))
You can use the same method to write the formulas for other columns, let us know if you succeeded.
Catalin
