Building a spread sheet for oil field use

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You will have to do two things, First build the table showing common
sizes in one column and required number in the other.
Then through Data Validation, List do a DropDown box for the common
sizes, and write Vlookup formula to see the different number from the
table, where you want to show it.

AQIB RIZVI
 
Back
Top