Using IF with VLOOKUP or another LOOKUP Formula

[jeromyl]

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.