| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populate this cell based on what's typed in this cell
How do I do this?
In my budget spreadsheet, need to auto-populate an entry in Column E based on what is typed in Column A. Have account #'s 200-294. If "213" is typed in any cell in Column A - I want the cell in that same row of Column E to read "Computers". If "294" is typed in Column A, I want Column E in that row to say "Vehicles". I have 31 accounts (column A) that need to be matched w/ a category (column E) which is too much for the IF formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto populate this cell based on what's typed in this cell
You should use VLOOKUP().
Very well explained: http://www.contextures.com/xlFunctions02.html -- Gary''s Student - gsnu200844 "CrazyChic" wrote: How do I do this? In my budget spreadsheet, need to auto-populate an entry in Column E based on what is typed in Column A. Have account #'s 200-294. If "213" is typed in any cell in Column A - I want the cell in that same row of Column E to read "Computers". If "294" is typed in Column A, I want Column E in that row to say "Vehicles". I have 31 accounts (column A) that need to be matched w/ a category (column E) which is too much for the IF formula. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto populate this cell based on what's typed in this cell
Worked like a charm - Thanks!!!!!
"Gary''s Student" wrote: You should use VLOOKUP(). Very well explained: http://www.contextures.com/xlFunctions02.html -- Gary''s Student - gsnu200844 "CrazyChic" wrote: How do I do this? In my budget spreadsheet, need to auto-populate an entry in Column E based on what is typed in Column A. Have account #'s 200-294. If "213" is typed in any cell in Column A - I want the cell in that same row of Column E to read "Computers". If "294" is typed in Column A, I want Column E in that row to say "Vehicles". I have 31 accounts (column A) that need to be matched w/ a category (column E) which is too much for the IF formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto populate a cell based off a look up table | Excel Discussion (Misc queries) | |||
| How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
| How do I Auto Populate a cell with a chart based on a value | Excel Worksheet Functions | |||
| formula to auto populate zip when city is typed in Excel | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Linear Mode
