Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set value in column based on value in ajoining column
I update a spread sheet with a name in one column that uses letters and
numbers and then manually put in a numeric value in the ajoining column. I'd like to automate this process. I need to be able to search a list of 35-40 names and then have excel place a predefined number in the next column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set value in column based on value in ajoining column
Set up a table somewhere in your spreadsheet (assume X1:Y40 on the
same sheet), made up of your list of names in column X and the corresponding number in column Y. Then, if you enter your name in A2, put this formula in B2: =IF(A2="","",VLOOKUP(A2,X$1:Y$40,2,0)) The formula can be copied down column B for as many items as you are likely to input in column A. Hope this helps. Pete On May 29, 10:14 pm, Docmidnite wrote: I update a spread sheet with a name in one column that uses letters and numbers and then manually put in a numeric value in the ajoining column. I'd like to automate this process. I need to be able to search a list of 35-40 names and then have excel place a predefined number in the next column. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set value in column based on value in ajoining column
Sounds like you could use a lookup table and some VLOOKUP formulas in a column.
See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Tue, 29 May 2007 14:14:00 -0700, Docmidnite wrote: I update a spread sheet with a name in one column that uses letters and numbers and then manually put in a numeric value in the ajoining column. I'd like to automate this process. I need to be able to search a list of 35-40 names and then have excel place a predefined number in the next column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill a column with the contents of another column based on a choic | Excel Discussion (Misc queries) | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions |