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!

33 thoughts on “Excel searching and formulas

  1. brilliantlighttherapy

    I believe this site holds some real superb information for everyone :D. “When you get a thing the way you want it, leave it alone.” by Sir Winston Leonard Spenser Churchill.

  2. Acheter Reductil

    Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

  3. Phentermine kaufen

    Thanks for all your work on this website. My niece loves conducting internet research and it’s simple to grasp why. We know all of the dynamic mode you produce informative information via the blog and in addition boost participation from other people about this article and our girl is becoming educated a lot of things. Have fun with the rest of the year. You are always doing a very good job.

  4. ephedrin kaufen

    Hey, you used to write wonderful, but the last several posts have been kinda boring… I miss your super writings. Past few posts are just a little out of track! come on!

  5. Online

    A person essentially help to make seriously articles I would state. This is the first time I frequented your website page and thus far? I amazed with the research you made to make this particular publish amazing. Great job!

  6. Ephedrine online kaufen

    Pretty nice post. I simply stumbled upon your weblog and wanted to say that I have truly loved surfing around your weblog posts. In any case I’ll be subscribing on your rss feed and I hope you write once more very soon!

  7. ig

    We absolutely love your blog and find a lot of your
    post’s to be exactly what I’m looking for. can you offer guest writers to write content
    for yourself? I wouldn’t mind composing a post or elaborating on most of the subjects you write in relation to here.
    Again, awesome web log!

  8. Mauricio

    Hello exceptional blog! Does running a blog similar to this require a great deal of work?
    I have absolutely no understanding of coding but I was hoping to start my own blog
    soon. Anyway, should you have any suggestions
    or techniques for new blog owners please share. I know this is off subject nevertheless I simply had to ask.


  9. get

    I’ve read a few good stuff here. Certainly worth bookmarking for revisiting. I surprise how a lot attempt you set to make one of these fantastic informative website.

  10. Buy Cold Relief

    Today, I went to the beachfront with my children. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is totally off topic but I had to tell someone!

  11. StacySap

    I love perusing your web orientation. Acknowledge gratitude you! [url=http://it.cgtribc.org/settimana-di-dieta-disintossicante/]http://it.cgtribc.org/settimana-di-dieta-disintossicante/[/url]

  12. HectorMow


    Extremely enlightening, look ahead to visiting again.

  13. vurtilopmer

    You actually make it seem really easy with your presentation but I in finding this topic to be really one thing that I feel I’d by no means understand. It seems too complicated and extremely large for me. I’m taking a look ahead in your subsequent publish, I will attempt to get the cling of it!

Comments are closed.