Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting selection in a cell AND linking that selection to a list
-- I am attempting to create a tamper proof worksheet that will rely on a drop down list for the initial selection. THEN I need a linked dollar amount to appear in another cell in that row. A B CODES COST This is the This is the drop down cell that needs cell to link an amount to the selection in A I have tried =vlookup and I keep getting a circular ref warning. There are other columns involved, but they can be moved before calculations will be added. Lisa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting selection in a cell AND linking that selection to a list
Can we get a better idea of where the information is that you need to link to
in column B? Perhaps that non-functional VLOOKUP() formula you had would give us some insight into things. "Lisa" wrote: -- I am attempting to create a tamper proof worksheet that will rely on a drop down list for the initial selection. THEN I need a linked dollar amount to appear in another cell in that row. A B CODES COST This is the This is the drop down cell that needs cell to link an amount to the selection in A I have tried =vlookup and I keep getting a circular ref warning. There are other columns involved, but they can be moved before calculations will be added. Lisa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating a cell from a list selection | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Linking a selection in a drop down list to a calc in another cell | Excel Worksheet Functions | |||
Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |