Compare two cells on each Worksheet then Add value

[Harley78]

Hello all,

I have been trying for a week and a half to do it on my own, but harder than I thought.

I have one worksheet with suppliers and the shipments air or sea and delivery times

Excel Workbook
	A	B	C	D	E	F	G
1	Supplier	Mode of Transport	Ship Date	ETA Port	ETA to Plant	Delivered	Diff
2	Supplier A	S	14-May	14-Jun	18-Jun	18-Jun	35
3	Supplier B	S	14-May	14-Jun	18-Jun	18-Jun	35
4	Supplier C	A	14-Jun		18-Jun	18-Jun	4
5	Supplier D	S	24-Apr	27-May	31-May	5-Jun	42
6	Supplier E	S	8-May	30-May	3-Jun	8-Jun	31
7	Supplier F	S	24-Apr	27-May	31-May	5-Jun	42
Sheet1

And I have a Pivot Table that gives me the average length of time for each transportation method.

Excel Workbook
	A	B	C	D	E
10	Days	Type
11	Supplier	A	G	S	Total Shipments
12	Supplier A			28.6	0
13	Supplier B			38.0	0
14	Supplier C	7.3			0
15	Supplier D	7.7			0
16	Supplier E	2.0	4.1		0
17	Supplier F		4.0		0
Sheet1

I manually enter the ETA to plant (Column E) however I want to do it automatically.

Looking at Supplier A and Mode of Transport on the first sheet if the supplier matches, then if Mode is S on first sheet, then I want it to use the cell under the S that is in the pivot table (in this case, 28.6 from second sheet) to cell E2 (in cell E2 on first sheet - like it to represent C4+ cell from the pivot table [28.6])

I hope I stated it correctly and clearly.

Any help would be appreciated.

thanks yet again,

Bill

 

[Harley78]

Or can it not be done?