Question description:
This user has given permission to use the problem statement for this
blog.
how do i create a formula to change a number to a line of text, ie i have about 20 descriptions of tasks on a timesheet, and instead of repeatedly typing text i was wondering if i could create a short cut..
ie. type the number 1 or a short cut and a line of text appears in the cell.. for example
task 1 : meeting on site to discuss measurements.
task 2: meeting in house with MD to discuss progress
and so on
Solved by S. D. in 58 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/08/2018 - 11:06
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
Excelchat Expert
16/08/2018 - 11:08
From what I've understood in your problem description, you want to automatically return a particular text when its "code" is entered in another cell. Like when you Enter "Task 1", you want a formula in another cell to return "Meeting on site to discuss measurements." Is this correct?
Excelchat Expert
16/08/2018 - 11:12
I believe this can be done with the use of a VLOOKUP function. Let me provide you a solution using the examples you've stated in the document preview.3
Excelchat Expert
16/08/2018 - 11:15
Okay, already done! If you look at cell C3, we have the following formula: =IF(B3="","",VLOOKUP(B3,'Source sheet'!$A:$B,2,0))
Excelchat Expert
16/08/2018 - 11:16
This formula states that IF cell B3 is blank (meaning no code was entered), C3 would be blank as well. However, if cell B3 has a code, the VLOOKUP function will return the description of that code.
Excelchat Expert
16/08/2018 - 11:17
You can just drag down the formula for the other codes in column B as well.
User
16/08/2018 - 11:18
yes i can see chat box
Excelchat Expert
16/08/2018 - 11:18
I can see that you've been active in the document preview! I hope you'd be able to communicate in this chatbox as well.
Excelchat Expert
16/08/2018 - 11:18
Oh nice! I thought there were concerns with our communication.
Excelchat Expert
16/08/2018 - 11:18
If you go to "Source sheet", you'll see a list of codes and their respective description.
User
16/08/2018 - 11:18
sorry it is the first time i have used this site.. amazing
Excelchat Expert
16/08/2018 - 11:19
Oh okay I see. Don't be afraid, we're a legit platform. :)
Excelchat Expert
16/08/2018 - 11:20
So in the source sheet, you just need to fill in what code corresponds to what description. In the main sheet, using our formula, you can now return the description corresponding to a code you typed. :)
User
16/08/2018 - 11:20
thank you.. so basically i would create the text etc in source sheet then in the main sheet i would type the formal?
Excelchat Expert
16/08/2018 - 11:20
Yes, that is correct. :)
Excelchat Expert
16/08/2018 - 11:21
If you can share the file you're working on, I can directly input the formula and reference as necessary so that you'd just be adding in codes and descriptions in another sheet.
Excelchat Expert
16/08/2018 - 11:22
If you can't share, you can always download the document preview for your reference.
Excelchat Expert
16/08/2018 - 11:22
You can download a copy of the document preview by going to File > Download as > Microsoft Excel (.xlsx). The formulas will be downloaded as well. :)
User
16/08/2018 - 11:23
oh wow!! that would be great... but i am at home and do not have my files at home.. i have just started a new job, and i need to update some work books and need to know more!..
Excelchat Expert
16/08/2018 - 11:24
Okay, noted on that. You can just download the file then for your reference. Do you have any more clarifications with the provided solution? :)
Excelchat Expert
16/08/2018 - 11:25
If you don't have any more clarifications at this point, you may end the session by clicking the END SESSION on the upper right of your screen.
Excelchat Expert
16/08/2018 - 11:25
Also, I'd appreciate if you could drop a few lines for your great feedback on a survey after this session. Many thanks and have a great day!
Excelchat Expert
16/08/2018 - 11:27
Hi! I can see that you're still active in the document preview. Please do ask if you have any more clarifications with the provided solution.
Excelchat Expert
16/08/2018 - 11:29
Hello? :)
User
16/08/2018 - 11:29
oh course i will thank you .. how can i save this document in order for me to use this as a help sheet?
Excelchat Expert
16/08/2018 - 11:29
You can download a copy of the document preview by going to File > Download as > Microsoft Excel (.xlsx). The formulas will be downloaded as well. :)
User
16/08/2018 - 11:30
thank you.. i know sounds stupid but how can i see if it is downloading?
Excelchat Expert
16/08/2018 - 11:31
Oh, you should be able to see it in your Downloads folder. :)
User
16/08/2018 - 11:31
it is not showing there?
User
16/08/2018 - 11:32
also how do i print this page showing formulas?
Excelchat Expert
16/08/2018 - 11:33
Okay, let's try another approach. I've uploaded the same file here. If you hover over the green EXCEL icon, a download button should appear on its upper right portion. Click this button to download.
[Uploaded an Excel file]
User
16/08/2018 - 11:34
nope still not? is it because i am on a mac
User
16/08/2018 - 11:35
also how do i print this page showing formulas?
Excelchat Expert
16/08/2018 - 11:35
Okay, please see column D
[Uploaded an Excel file]
Excelchat Expert
16/08/2018 - 11:36
I've uploaded a picture in our chat. If you hover over your mouse on the green EXCEL icon, a download button should appear
[Uploaded an Excel file]
Excelchat Expert
16/08/2018 - 11:39
Another picture to guide you. This is how to download the document preview.
[Uploaded an Excel file]
Excelchat Expert
16/08/2018 - 11:41
Were you able to download the file? :)
User
16/08/2018 - 11:42
no still nothing there?
Excelchat Expert
16/08/2018 - 11:43
Okay, here's what we can do instead. I'll contact our support team to send you the document preview over the email you used for ExcelChat. Will that be okay? :)
Excelchat Expert
16/08/2018 - 11:44
This is so you can just receive the file we've worked in your email address and download it as attachment from there.
Excelchat Expert
16/08/2018 - 11:45
Hello? :)
User
16/08/2018 - 11:47
yes please.. sharon@madden-home.co.uk
User
16/08/2018 - 11:47
you are an absolute star! i can't thank you enough!
Excelchat Expert
16/08/2018 - 11:47
Okay, noted on this. Thanks for your appreciation!
Excelchat Expert
16/08/2018 - 11:48
Nice! You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)
User
16/08/2018 - 11:49
what is your name or reference so i can give you a great feedback
Excelchat Expert
16/08/2018 - 11:49
Oh, when you end the session, you'll be able to provide a feedback from there. Unfortunately, we can't disclose personal information as part of our company policy. :)
Excelchat Expert
16/08/2018 - 11:51
You may end the session by clicking the END SESSION on the upper right of your screen.
Excelchat Expert
16/08/2018 - 11:53
Do you have any more concerns by the way? :) We can only start sending the file by the way after the session ends. Please be rest assured that you'll receive your file via email afterwards. :)
Excelchat Expert
16/08/2018 - 11:55
Hello? :)
User
16/08/2018 - 11:56
hi just one more quick question
Excelchat Expert
16/08/2018 - 11:56
Sure thing, please do.
User
16/08/2018 - 11:56
so if i now type 1 in column b ie row 12... how will that text be there?
Excelchat Expert
16/08/2018 - 11:57
You can copy the formula in cell C7 and paste it in cell C8,.
Excelchat Expert
16/08/2018 - 11:57
Just copy the cell down.,
Excelchat Expert
16/08/2018 - 11:58
You don't need to copy column DE.
Excelchat Expert
16/08/2018 - 11:58
D.
Excelchat Expert
16/08/2018 - 11:58
Just column C>
Excelchat Expert
16/08/2018 - 11:58
Copy down column C, not D.
User
16/08/2018 - 11:59
duh!!!! thank you!
Excelchat Expert
16/08/2018 - 11:59
Okay, nice! If you don't have any more clarifications at this point, you may end the session by clicking the END SESSION on the upper right of your screen.
Excelchat Expert
16/08/2018 - 11:59
Also, I'd appreciate if you could drop a few lines for your great feedback on a survey after this session. Many thanks and have a great day!
Excelchat Expert
16/08/2018 - 12:02
By the way, we can only extend two times per session. I hope we were able to address your main concern. Since you can't download the file to your unit, I'll be sending ti over through your support team.
Excelchat Expert
16/08/2018 - 12:04
The session is about to end. To end it immediately, you can just press the END BUTTON (red one) on the upper right of your screen. I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)
User
16/08/2018 - 12:04
thank you
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
