Thread: Building a spread sheet for oil field use
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aqib Rizvi[_2_] Aqib Rizvi[_2_] is offline
external usenet poster
  
Posts: 40
Default Building a spread sheet for oil field use
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
Reply With QuoteReply With Quote