Confused

[randombloke99]

Hi, newbie here!

Im trying to complete my cable calculator tool and wanted to add some automation to it. I have added some parts but stuck with others

I would like to use G17 to take the value calculated in G15, apply it to the table in whichever column selected in G2. I have got it working to some degree using =VLOOKUP(G15,L6:N22,MATCH(G2,L4:N4,0),-1) but I need the value to be equal or greater than G15. So in this instance:
G2= SINGLE-PHASE AC
G15 = 32A
So i need G17 to return with 39A (L10)
I would also like to then have G18 to display 6 (K10)

Any help greatly appreciated.

Paul

 

[randombloke99]

How do I attach my screenshot?...

 

[Joe4]

There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Fluff]

Beaten 2it again

 

[randombloke99]

Ive downloaded the forum tools link and has added a toolbar in excel, can't see how to add this to my post?

 

[randombloke99]

The copy tabs don't seem to do anything when pasting in test page. Just comes up as plain text
[TABLE="width: 1577"]
<colgroup><col span="5"><col><col><col><col span="3"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]Single / Three Phase System[/TD]
[TD]SINGLE-PHASE AC[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]Voltage (L - N / L - L) =[/TD]
[TD]230[/TD]
[TD]Volts[/TD]
[TD][/TD]
[TD][/TD]
[TD]NOMINAL CSA[/TD]
[TD="colspan: 3"]Current Carrying Capacity[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SINGLE-PHASE AC[/TD]
[TD]THREE-PHASE AC[/TD]
[TD]2 SINGLE-CORE CABLES TOUCHING[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]mm.[/TD]
[TD]Amps[/TD]
[TD]Amps[/TD]
[TD]Amps[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ib[/TD]
[TD="colspan: 4"]Circuit Design Current[/TD]
[TD]32[/TD]
[TD]Amps[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]In[/TD]
[TD="colspan: 4"]Circuit Protective Device[/TD]
[TD]32[/TD]
[TD]Amps[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]25[/TD]
[TD]20[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]Correction Factors[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]30[/TD]
[TD]26[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ca[/TD]
[TD="colspan: 4"]Ambient temperature *C[/TD]
[TD]30[/TD]
[TD]Shaded from Sunlight[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]39[/TD]
[TD]34[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cg[/TD]
[TD="colspan: 4"]Grouping - No. Of Circuits / Cables[/TD]
[TD]1[/TD]
[TD]Bunched Together[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]51[/TD]
[TD]47[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CgN[/TD]
[TD="colspan: 4"]Number of loaded cores[/TD]
[TD]≤ 4[/TD]
[TD]De-rating Factor[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]16[/TD]
[TD]73[/TD]
[TD]63[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ci[/TD]
[TD="colspan: 4"]Length Covered by Thermal Insulation (mm)[/TD]
[TD]0[/TD]
[TD]De-rating Factor[/TD]
[TD]1[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD]97[/TD]
[TD]83[/TD]
[TD]-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]It =[/TD]
[TD="colspan: 4"]Tabulated Current Carrying Capacity Required[/TD]
[TD]32.0[/TD]
[TD]Amps[/TD]
[TD][/TD]
[TD][/TD]
[TD]35[/TD]
[TD]140[/TD]
[TD]102[/TD]
[TD]140[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]50[/TD]
[TD]-[/TD]
[TD]124[/TD]
[TD]175[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Iz[/TD]
[TD="colspan: 4"]Actual Selected Cable CCC (A) =[/TD]
[TD]30[/TD]
[TD]Amps[/TD]
[TD][/TD]
[TD][/TD]
[TD]70[/TD]
[TD]-[/TD]
[TD]158[/TD]
[TD]216[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]Actual Selected Cable CSA[/TD]
[TD] [/TD]
[TD]mm2[/TD]
[TD][/TD]
[TD][/TD]
[TD]95[/TD]
[TD]-[/TD]
[TD]192[/TD]
[TD]258[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]120[/TD]
[TD]-[/TD]
[TD]222[/TD]
[TD]302[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]150[/TD]
[TD]-[/TD]
[TD]255[/TD]
[TD]347[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Ib ≤ In ≤ Iz[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]185[/TD]
[TD]-[/TD]
[TD]291[/TD]
[TD]394[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]32[/TD]
[TD]32[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]240[/TD]
[TD]-[/TD]
[TD]343[/TD]
[TD]471[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[randombloke99]

[TABLE="width: 1403"]
<colgroup><col span="4"><col><col><col><col span="3"><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[randombloke99]

That was painful! managed to attach via a hidden page and link on my website!

Any help with the excel problem greatly appreciated!!