Find and Replace
- Thread starter jack999
- Start date
Abhijeet R. Joshi
Active Member
Agreed with Xiq, and in case you need an IF formulas to just mention the values "Bill No" and "Goods Return" in col.G when checked with the data in Col.C then below should help
Sir, In Invoice-Cash-Cheque sheet Column C contain Bill No..... , Credit Note , Cash Transfer etc..
I want to add in the same sheet Col. G if Col. C Contain Bill No.... Then Invoice , If Credit Note then Goods Return Etc..
how many if can we use in one command line
I copy paste the formula in col G but noting happened
Please check Invoice-Cash-Cheque sheet
Smallman
Excel Ninja
Hi Jack
This seems to do the trick. File attached.
=CHOOSE(LOOKUP(8,SEARCH({"Cash T","Discount","Goods","Bill","Cash R","Cheque","Sales","Cash T/"}, C3)*{1,2,3,4,5,6,7,8}),"Cash T","Discount", "Goods R", "Invoice", "Cash R", "Cheque", "Sales","Cash T/F","Cash T")
Take care
Smallman
This seems to do the trick. File attached.
=CHOOSE(LOOKUP(8,SEARCH({"Cash T","Discount","Goods","Bill","Cash R","Cheque","Sales","Cash T/"}, C3)*{1,2,3,4,5,6,7,8}),"Cash T","Discount", "Goods R", "Invoice", "Cash R", "Cheque", "Sales","Cash T/F","Cash T")
Take care
Smallman
Smallman
Excel Ninja
Hi Jack
Did you want to add some text with you post - perhaps a;
Thanks for your efforts...
or;
Thanks but I have another question regarding the formula.
Note the prefix of each suggestion. I would start with that for anyone who offered assistance from their own time and genuinely out of kindness.
I thought my formula nailed your question however if you could start with addressing these simple vagaries, that would be fantastic.
Take care
Smallman
Did you want to add some text with you post - perhaps a;
Thanks for your efforts...
or;
Thanks but I have another question regarding the formula.
Note the prefix of each suggestion. I would start with that for anyone who offered assistance from their own time and genuinely out of kindness.
I thought my formula nailed your question however if you could start with addressing these simple vagaries, that would be fantastic.
Take care
Smallman
Xiq
Active Member
Hi Jack,
We already stated your request isn't clear to us. So referring to the same unclear-post isn't very helpful. Try to give an example of your desired result.
Sir here I posted my requirement as in Column G of Invoice Cash Cheque.@Smallman
Hi!
I think that OP didn't even realize what we were talking about
Regards!
PS: BTW, good job and great patience...
Hoping you do the needful
@Smallman
Hi!
I think that OP didn't even realize what we were talking about
Regards!
PS: BTW, good job and great patience...
Sirs, Suppose I have an Excel Sheet, and its column C contains Narration like Bill No.1568, Bill No.1569, Bill No. 1570, Cash Received, Cheque Received, Credit Note, Cash Trasfer to A/C etc..
I want to add Unique Text in Column G as Like Below
Bill No.1568 - Invoice
Bill No.1569 - Invoice
Cash Received - Cash Received
Credit Note - Sales Return
Cash Transfer to A/C Cash Transfer
How can add these unique text Column G.
@Smallman
Hi!
I think that OP didn't even realize what we were talking about
Regards!
PS: BTW, good job and great patience...
Sirs, above I posted a clear picture what I require, please look into this matter
Smallman
Excel Ninja
Jack
Do us all a big favour - read your first post (Post 1). Now read post 17. Now tell me if you were us, would you be confused too? This sort of flip flop behaviour makes people who give their time freely scratch their heads.
The answer to your question Q16 not Q1 which I believe has been answered is;
=C3&" "&CHOOSE(LOOKUP(8,SEARCH({"Cash T","Discount","Goods","Bill","Cash R","Cheque","Sales","Cash T/"}, C3)*{1,2,3,4,5,6,7,8}),"Cash T","Discount", "Goods R", "Invoice", "Cash R", "Cheque", "Sales","Cash T/F","Cash T")
Now add to your own learning by adapting some of the text inside if it is not exactly what you want. Do a bit of work for yourself so we can see you have at least tried before coming back to the forum with the old chestnut "It is not what I asked for..."
Good day Sir
Smallman
Do us all a big favour - read your first post (Post 1). Now read post 17. Now tell me if you were us, would you be confused too? This sort of flip flop behaviour makes people who give their time freely scratch their heads.
The answer to your question Q16 not Q1 which I believe has been answered is;
=C3&" "&CHOOSE(LOOKUP(8,SEARCH({"Cash T","Discount","Goods","Bill","Cash R","Cheque","Sales","Cash T/"}, C3)*{1,2,3,4,5,6,7,8}),"Cash T","Discount", "Goods R", "Invoice", "Cash R", "Cheque", "Sales","Cash T/F","Cash T")
Now add to your own learning by adapting some of the text inside if it is not exactly what you want. Do a bit of work for yourself so we can see you have at least tried before coming back to the forum with the old chestnut "It is not what I asked for..."
Good day Sir
Smallman
Thanks a lot for kind help sir.
I apologize my mistake. It was just happened due to my hurry. I wrongly attached that file. I know you were spending your time for helping others. I think it just happened on only this post. So please close this chapter here.
Ok. Thanks & Regards