i have got myself utterly lost!

[mistersteve]

I ma hoping anyone can help me.
I have a list of columns as below, and I call it my results Page

End Cust A/C	Material	Qty.		List/Spec. Nett Price	UOM	Disc. Group	List/Spec. * Qty.	Cust. Disc.	E/C Nett Price	Margin
8901340	0117960000	25		31.17	100	0011A	7.79	35	5.07	14

<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" span="2"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="12" style="width: 9pt; mso-width-source: userset; mso-width-alt: 438;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="42" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1536;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;"> <tbody> </tbody>

The List/Spec column check to see if the customer has any special prices and inputs them, if not it enters the std. list price.
=IFERROR(IF($D8<=0,"",IF(ISNUMBER(VLOOKUP($C8,INDIRECT($C$3),5,0)),VLOOKUP($C8,INDIRECT($C$3),5,0),VLOOKUP($C8,Prices,5,0))),0)
This also applies to the UOM and Disc. Group columns.

The Cust. Disc. is derived from below

Group 1	Margin 1	Group 2	Margin 2	Group 3	Margin 3
0011A	10	0011E	10	0055A	10
0011A	7.5	0011E	7.5	0055A	7.5
0011E	14
0011A	10	0011E	10	0055A	10

<colgroup><col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" span="5"> <col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;"> <tbody> </tbody>

Matching the Group it display the discount adjacent.
=IFERROR(IF($D8<=0,"",OFFSET(INDEX(Cost_Disc._Groups,MATCH($B8,Accounts,0),MATCH($H8,'ACC, Group Disc, and Specials'!$P$4:$AA$4,0)),0,1)),0)
However, if, as I said earlier there is a spec. price the Disc. group remains blank.

Problem I have is that I still require the profit column to be added.


This is one of my special prices list, there are a few.
A/C

8901340

<colgroup><col width="144" style="width: 108pt; mso-width-source: userset; mso-width-alt: 5266;"> <tbody> </tbody>

Material	Description	Blank	Blank	Cust. Special	Per	Support	Per	Margin
1061200000	WEW 35/2	Blank		26.00	100	22.36	100	14
0383560000	EW 35			33.00	100	28.38	100	14

<colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="144" style="width: 108pt; mso-width-source: userset; mso-width-alt: 5266;"> <col width="64" style="width: 48pt;"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" span="6"> <tbody> </tbody>

I need to extract from the Margin column and insert into my results page after determining the A/c and material is special price

I hope I haven't complicated thing and hope someone can help.

Thank you in advance