Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about using VLOOKUP with Data validation
I have a list in Excell 2003 that I have set to use for data validation on a
worksheet. I also have a list of numbers that I would like added to the main spreadsheet in a certain cell with the correct amount when the data validation equals any number of data validations. I.E. cell A1 contains a name of a group on my list page which is data validated with the name of group and added to the main work sheet in column A. cell A2 on the list page contains the number of people that are in that group. Cell A2 on my main spreadsheet is where I want the number in the group to appear when I select any group I choose, each group number is on the same row as the group name. any help would be appreciated. Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about using VLOOKUP with Data validation
You can use a VLookup formula to return the number of people when a
group is selected. There's information in Excel's Help, and he http://www.contextures.com/xlFunctions02.html ralphdevlin via OfficeKB.com wrote: I have a list in Excell 2003 that I have set to use for data validation on a worksheet. I also have a list of numbers that I would like added to the main spreadsheet in a certain cell with the correct amount when the data validation equals any number of data validations. I.E. cell A1 contains a name of a group on my list page which is data validated with the name of group and added to the main work sheet in column A. cell A2 on the list page contains the number of people that are in that group. Cell A2 on my main spreadsheet is where I want the number in the group to appear when I select any group I choose, each group number is on the same row as the group name. any help would be appreciated. Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Another Data Validation question | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) | Excel Discussion (Misc queries) |