LinkBack URL
About LinkBacks
If the first cell A1 is "Cold weather" then second cell B1 shows "1" and if A1 is "Warm weather" then B1 is "2" or if A1 is "Hot weather" then B1 is "3".
Please assist!
If a cell contains specific text then another cell brings specific number
If the first cell A1 is "Cold weather" then second cell B1 shows "1" and if A1 is "Warm weather" then B1 is "2" or if A1 is "Hot weather" then B1 is "3".
Please assist!
Try
B1Formula:
Please Login or Register to view this content.
Last edited by shukla.ankur281190; 11-01-2017 at 05:03 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
welcome to the forum. maybe:
=MATCH(A1,{"Cold Weather","Warm weather","Hot weather"},0)
if you have a lot more, do consider doing VLOOKUP. have a list in column G and the numbers in column H. then:
=VLOOKUP(A1,G:H,2,0)
i developed a tool to help people learn VLOOKUP. try downloading this file here:
https://www.excelforum.com/tips-and-...-how-tool.html
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Try this in B1
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Still no luck
What
Perhaps you are not using Excel
Do you have " " around the value in A1?
If you do, remove the quote marks
See it working in attached file
- select value from dropdown in A1
Last edited by kev_; 11-01-2017 at 05:11 AM.
I get the same error for all the solutions.
Error 1.png
Did you look at the attached workbook in post#7
Try
Formula:Please Login or Register to view this content.
Change "," to ";"
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
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
Hurray
Thanks a million, it works!
Where are you based?
Some country versions require , in-between values
other versions require ;
JHB = Johannesburg,... probably. the OP's profile is NOT particularly helpful as it is not obvious where (s)he is located.
NOw you have your answer - please mark thread as SOLVED
Go to thread tools at top of thread
This one works too.. Thanks so much!
I am in Johannesburg South Africa. Yes I have chaged "," to ";"
Thanks to @shukla.ankur281190
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks