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

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