Excel searching and formulas

Ok, so I’ve got a spreadsheet with a list of pipe sections with the following properties:
column A: diameter
column B: thickness
column C: section area
column D: moment of inertia
column E: inertial radius
In another spreadsheet I would like to have two cells in which I write the diameter and thickness of a pipe and using these parameters excel to fill another 3 cells automatically with the remainder of the properties (by searching the other spreadsheet – with the list, finding the afferent pipe). How do I do that? Any help would be appreciated!

One thought on “Excel searching and formulas

Leave a Reply

Your email address will not be published. Required fields are marked *