Using IF with VLOOKUP or another LOOKUP Formula

jeromyl

New Member
Joined
May 26, 2018
Messages
1
Hi guys new to the forum. I am a Bim coordinator for a electrical contractor that I am also getting into some engineering. So I am trying to make a Conduit sizing calculator that when you enter in the amount of wires and the wire type that it calculates the area of the wire and totals the area of all the wires. I was able to get this part to work so now I am trying to get that total area to use another chart that has conduit size and conduit type and it has a area that can be filled and chose the right conduit size. Something along the lines of if total wie area is equal to or less then a certain conduit size matched with a certain conduit type that it will pick the correct conduit size.

[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD]No. Of Conductors[/TD]
[TD]Conductor size[/TD]
[TD]Conductor type[/TD]
[TD="align: center"]Total Area[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8[/TD]
[TD]THHN[/TD]
[TD].1098[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]THHN[/TD]
[TD].1098[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Conduit type[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Minimum Conduit Size[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="width: 200, align: center"]
<tbody>[TR]
[TD]Conduit Size[/TD]
[TD]EMT[/TD]
[TD]RMC[/TD]
[TD]IMC[/TD]
[/TR]
[TR]
[TD]3/4"[/TD]
[TD].213[/TD]
[TD].22[/TD]
[TD].235[/TD]
[/TR]
[TR]
[TD]1"[/TD]
[TD].346[/TD]
[TD].355[/TD]
[TD].384[/TD]
[/TR]
</tbody>[/TABLE]

I have something like this I also have a chart for wire on same sheet as conduit But I have it figured out. So basically Conduit type will have a pull down to select conduit type the minimum conduit size is were I need the formula. I wanting to be that the total area of combined wire size if equal to or less then a value for the type of conduit and size then it is that conduit size.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top