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

		Single / Three Phase System	SINGLE-PHASE AC
		Voltage (L - N / L - L) =	230	Volts			NOMINAL CSA	Current Carrying Capacity
										SINGLE-PHASE AC	THREE-PHASE AC	2 SINGLE-CORE CABLES TOUCHING
										mm.	Amps	Amps	Amps
	Ib	Circuit Design Current	32	Amps			1	10	10	-
	In	Circuit Protective Device	32	Amps			2	16	16	-
										3	25	20	-
	Correction Factors				4	30	26	-
	Ca	Ambient temperature *C	30	Shaded from Sunlight	1		6	39	34	-
	Cg	Grouping - No. Of Circuits / Cables	1	Bunched Together	1		10	51	47	-
	CgN	Number of loaded cores	≤ 4	De-rating Factor	1		16	73	63	-
	Ci	Length Covered by Thermal Insulation (mm)	0	De-rating Factor	1
										25	97	83	-
	It =	Tabulated Current Carrying Capacity Required	32.0	Amps			35	140	102	140
										50	-	124	175
	Iz	Actual Selected Cable CCC (A) =	30	Amps			70	-	158	216
		Actual Selected Cable CSA		mm2			95	-	192	258
										120	-	222	302
										150	-	255	347
			Ib ≤ In ≤ Iz					185	-	291	394
			32	32	30					240	-	343	471

<colgroup><col span="5"><col><col><col><col span="3"><col><col><col><col></colgroup><tbody>
</tbody>

 

[randombloke99]

<colgroup><col span="4"><col><col><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>

 

[randombloke99]

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

Any help with the excel problem greatly appreciated!!