Calculate whether the entry in the Invoice sheet is FALSE or TRUE against the list in Prdouct List sheet

[McTam]

Excel 2007
	A	B	C	D	E
1	Contracted	Item Description		Contracted	Product Description
2	TRUE	A4 BW Copy/ Print		FALSE	4D Ring File
3	FALSE	A4 BW Double Sided Copy/ Print		FALSE	A0 Colour Plot - Line
4	TRUE	A4 Colour Copy/ Print		FALSE	A0 Black & White Scan to File
5	TRUE	A4 Double Sided Colour Copy/ Print		FALSE	A0 BW Copy/ Print
6	TRUE	A4 Heavyweight Paper/ Card		FALSE	A0 Colour Plot - Graphics
7	TRUE	Comb Bind		FALSE	A0 Colour Print - Photo Quality
8	TRUE	A3 Colour Copy/ Print		FALSE	A0 Colour Scan to File
9	TRUE	A3 Colour Copy/ Print		FALSE	A0 Encapsulation
10	TRUE	A3 Colour Copy/ Print		FALSE	A1 Black & White Scan to File
11	FALSE	Comb Bind		FALSE	A1 BW Copy/ Print
12	TRUE	Comb Bind		FALSE	A1 Colour Plot - Graphics
13	FALSE	Comb Bind		FALSE	A1 Colour Plot - Line
14	FALSE	4D Ring File
15
16		INVOICE DETAIL SHEET 1			PRODUCT LIST SHEET 2
Invoice Detail

I have had to put both sheets in one as I couldn't create the HTML. I think I need more practise.

 

[McTam]

Excel 2007
	A	B	C	D	E	F
1	Contracted	Item Description			Contracted	Product Description
2	TRUE	A3 Colour Copy/ Print			FALSE	Comb Bind
3	FALSE	Comb Bind			TRUE	A3 BW Copy/ Print
4	TRUE	A3 Colour Copy/ Print			TRUE	A3 DS BW Copy/ Print
5	TRUE	Comb Bind			TRUE	A4 BW Copy/ Print
6	TRUE	A3 Colour Copy/ Print			TRUE	A4 BW Double Sided Copy/ Print
7	FALSE	Comb Bind			TRUE	A3 Colour Copy/ Print
8	TRUE	A4 Heavyweight Paper/ Card			TRUE	A3 Double Sided Colour Copy/ Print
9	FALSE	A4 Double Sided Colour Copy/ Print			TRUE	A4 Colour Copy/ Print
10	TRUE	A3 Colour Copy/ Print			TRUE	A4 Double Sided Colour Copy/ Print
11	FALSE	Comb Bind			TRUE	A3 Heavyweight Paper/ Card
12	TRUE	A4 Heavyweight Paper/ Card			TRUE	A3 Tear Proof Paper
13	TRUE	A4 Colour Copy/ Print			FALSE	A3 Tinted Paper
14	TRUE	A4 BW Double Sided Copy/ Print			FALSE	A3 Tinted Card
15	FALSE	4D Ring File			TRUE	A4 100gsm Paper
16	TRUE	A3 Colour Copy/ Print			TRUE	A4 Heavyweight Paper/ Card
17	FALSE	Comb Bind			TRUE	A4 Tear Proof Paper
18	TRUE	A4 Heavyweight Paper/ Card			FALSE	A4 Tinted Paper
19	FALSE	A4 BW Double Sided Copy/ Print			FALSE	A4 Tinted Card
20	TRUE	A4 Colour Copy/ Print
21	TRUE	A4 Double Sided Colour Copy/ Print
22	TRUE	Comb Bind
23	TRUE	A4 BW Copy/ Print
Sheet 1 and 2

This shows the entries off better (I think)

Alex

 

[McTam]

Sorry I should have explained that the information on sheet two shows what items are included in the contract and which are not (FALSE TRUE). So in sheet one I need to show in column one that this is correct with the item in sheet two. Or is that making it more difficult to understand??
Hope I have explained well enough,

thanks again

Alexx

 

[McTam]

I am sorry I have been on holiday for a couple of weeks so haven't had a chance to look at my query. I wonder if someone can help me with this please. I notice there has been no response so it may be that I haven't explained enough?
Any help would be greatly appreciated,

thank you Alex