# Excel - IF Function Problem - Expert Solution

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
Excelchat Expert 16/08/2018 - 11:22
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
User 16/08/2018 - 11:30
Excelchat Expert 16/08/2018 - 11:31
User 16/08/2018 - 11:31
it is not showing there?
User 16/08/2018 - 11:32
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.
User 16/08/2018 - 11:34
nope still not? is it because i am on a mac
User 16/08/2018 - 11:35
Excelchat Expert 16/08/2018 - 11:35
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
Excelchat Expert 16/08/2018 - 11:39
Another picture to guide you. This is how to download the document preview.
Excelchat Expert 16/08/2018 - 11:41
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
Excelchat Expert 16/08/2018 - 11:45
Hello? :)
User 16/08/2018 - 11:47
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.