LinkBack URL
About LinkBacks
Hello,
Been trying to get to this IF funtion going but not having any luck.
If I type a city I want the answer to show if the city is West or East
Document is attached.
Thank you.
Hello,
Been trying to get to this IF funtion going but not having any luck.
If I type a city I want the answer to show if the city is West or East
Document is attached.
Thank you.
How do we know if they are east or west? I don't understand your data - please explain in more detail.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
For example we all know California is West therefore function would look like this =IF(ISNUMBER(SEARCH("California",C:C)),"W","E")
but my column has multiply cities, New York is East, false would show E. Las Vegas would show W which is true.
Hope this helps!
Sorry - I do not understand the data. Where are the lookup lists for east and west?
I am still waiting for you to clarify the data. I am not interested in the formula you think we need - just what raw data we have to work with and what it means. Please don't assume ANY understanding of what you think is obvious.
Raw data is attached.
No, sorry - you aren't understanding what we need. How is Excel meant to know whether to assign west or east? Where is the lookup list? There needs to be a master lookup list so that Excel can look at it and assign either east or west accordingly.
there is no lookup list that is all I have setup.
So what exactly are you trying to do? You haven't yet satisfactorily explained. How are you expecting Excel to decide whether a city should be east or west? Is it something to do with the number?
See all the columns with W and E, I don't want to enter them manually. When I type the city I want excel to search the city automatically enter W or E.
Yes, I understand that much.
The question is, how do I know which ones should be W and which ones E? You cannot write a formula without Excel being able to look that up somewhere.
Do you understand what I am saying here? Excel doesn't know instinctively which cities are in the east and which in the west, and nor do I. Where is Excel meant to search for this?
Can we try something simular like this =IF(ISNUMBER(SEARCH("New Orleans",E8)),"W","E") which one works for 1 city
how about something like =IF(ISNUMBER(SEARCH("New Orleans","Denver","Dallas","Houston","Utah","Okla City","Portland","Sacramento","San Antonio","Phoenix",Minnesota","Memphis",Golden State",E:E)),"W","E") bythe way these are cities in the west
Do you the cities in East as well ?
With a list and a index/match formula you can do it.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Cool...very much appreciated. Thank you.
All I needed was a lookup list and then I could have provided a solution, like the one you have been offered. If only you had given me that when I first asked for it in post #4 ...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
if you have another solution I'm interested in seeing it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks