I am trying to make a number equal a specific word. Or a 'phrase' equal a specific word. I am making schedules for a baseball league and I want to be able to assign a value 1,2,3,4 etc. to a specific city or town name.
For Example:
1=Toronto
2=New York
3=LA
4=Chicago
This way I can create a schedule 1@2 and 3@4 etc. and on sheet two it would display Toronto @ Newyork and LA @ Chicago.
Thanks in advance and if anyone has a better way of creating schedules please let me know.
You can try something like this:
Create a table as in D2:E5
then use formula in B2 and copy down for lookup
Formula:
Please Login or Register to view this content.
or you can also use VLOOKUP
Formula:Please Login or Register to view this content.
v A B C D E 1 Values Results Lookup Table 2 2 New York 1 Toronto 3 4 Chicago 2 New York 4 1 Toronto 3 LA 5 3 LA 4 Chicago
Last edited by AlKey; 02-13-2016 at 02:53 PM.
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
Thanks for the reply. I haven't used formulas very much in excel and am fairly new with it all. Do you mind explaining to me what that does such as the $ symbol. also where do I put the vlookup line?
Thanks,
The $ is used to make ranges absolute in order prevent them to change when the formula is copied down or across. The formula should be entered in cell B2. It says it in my post.
My apologies but I have one last question what does the 2,0 mean for =VLOOKUP(A2,$D$2:$E$5,2,0)
in a vlookup formula you select the A2 as the value that is your reference value, the $D$2:$E$5 is the reference area you are checking against. The assumption here is that the value A2 will be found somewhere between D2 and D5. Because he used the reference of E5 and a 2, that means that if the value in A2 is found in D2 to D5, when you find it go over to the second column (the 2 in the formula you are asking about) and pull back the value that it finds there. Then the 0 means that the match should be exact, you can also use "False" as that means the same thing.
Hope that helps.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks