Excel function or macros

Solved/Closed
Philip - Jun 14, 2010 at 09:14 AM
 Philip - Jun 15, 2010 at 03:01 AM
Hello,
I have a table in which every number from 1 to 52 expresses a specified text
For example 1 = Sofia
2 = London ...
I need a function where when I write a number between 1 and 52 it returns the specified text for this number.

Could someone help me because I do not have a clue. Thank you in advance.


2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 14, 2010 at 10:54 AM
You can use VLOOKUP. It is hard to give you a better answer without looking at how you have setup the sheet. If you need more help, could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0
Thank you for your fast answer but I found the solution.
Best regards, Philip
0