I have to go through the bank data. Must search in column B1 for the text "Tango" and if found I have to fill column A1 with the text "fuel"
search in B1: BEA NR:J041ZC 01.04.14/10.19 Tango Enschede 1 ENSCHED,PAS221
if found fill cell A1
A1: "fuel"
How do I do this?
Hello
Try the following formula:
Formula:
Please Login or Register to view this content.
*Note SEARCH is not case sensitive.
DBY
I get an error: The formula you entered contains errors. I do not know what kind of errors.
=IF(ISNUMBER(SEARCH("Tango",G94)),"Fuel","")
Try to replace comma with semi-colon.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Alkey that is the good solution. Alkey and DBY thanks for this quick answer. I can now fill all data correct and send it.
What do you see? Exactly. The formula should (does) work perfectly. See attached.
have you got calculation set to Manual? (Formulas/calculation/calculation options)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
That'll be it. He's in The Netherlands!!Originally Posted by AlKey
Here's another one...
=IF(COUNTIF(B1;"*Tango*");"Fuel";"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks