View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default 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