Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making a set value appear in a cell
Hi, I'm new to excel, I apologize if this question is too basic. I work for
an accountant, and I have to enter an account purpose and the account number for that purpose in a cell right next to it. Is there any way to enter the purpose and make the set value of the account number appear next to it automatically? For example if I enter ABC for purpose, can I make a (fake) account number of 50-5025-02 appear next to it automatically? And the same goes for other purposes and their respective account numbers. |
#2
|
|||
|
|||
You can do this using a VLOOKUP formula. First you would need to set up
a list of all the account purpose's and their respective account numbers - the lookup table, in this example on sheet1 range A1:B10. Then if you enter a purpose in A2 (on another sheet) in B2 you could have the formula: =VLOOKUP(A2,Sheet1!$A$1:$B$10,2,0) For more on vlookups see excel help and also http://www.contextures.com/xlFunctions02.html Hope this helps Rowan Aleksey Solovyov wrote: Hi, I'm new to excel, I apologize if this question is too basic. I work for an accountant, and I have to enter an account purpose and the account number for that purpose in a cell right next to it. Is there any way to enter the purpose and make the set value of the account number appear next to it automatically? For example if I enter ABC for purpose, can I make a (fake) account number of 50-5025-02 appear next to it automatically? And the same goes for other purposes and their respective account numbers. |
#3
|
|||
|
|||
Hi Aleksey,
Lookup formulas (lookup, vlookup, hlookup) would greatly help with this task. Use Excel's help ('F1') or do a google search for some examples. You will love working with excel !!! "Aleksey Solovyov" wrote: Hi, I'm new to excel, I apologize if this question is too basic. I work for an accountant, and I have to enter an account purpose and the account number for that purpose in a cell right next to it. Is there any way to enter the purpose and make the set value of the account number appear next to it automatically? For example if I enter ABC for purpose, can I make a (fake) account number of 50-5025-02 appear next to it automatically? And the same goes for other purposes and their respective account numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a cell Negitive only | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Is there a way of making data imput in to a cell mandatory before. | Excel Worksheet Functions | |||
Making comments apply to more than one cell | Excel Discussion (Misc queries) |