View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Philbert4420 Philbert4420 is offline
external usenet poster
 
Posts: 1
Default Building a spread sheet for oil field use

I am working on a spreaad sheet to help my co-workers and my self to do
abandanment plugs. what I need to do is be able to read a common size in the
drop down list but enter a differnt number into the formula.
A B C
1 Casing 4.5" X 10.5# .0159
2 7" X 17# .0417
for example if I chose 7" X 17# from the list it automaticly puts the .0417
into the formula
--
oilpatchdummie