Pulling info from second sheet into first database using if

[james_simpson1998]

Now what if I wanted to take it a step further...

what if i had a separate table on another sheet which told me, for example transit times in weeks. Lets use for example 4 weeks total transit time.

And what I would like to do is to insert a week number into cell M92 for example, and total transit time for this example is 4 weeks which is what is on the table on the other sheet. So, M92 = 35 (for example), i would like P92 to pull through the date of week 35, O92 to pull through P92-4 total weeks from the other table? Does this make sense?

To make things easier, lets use a live example of what I am trying to achieve.

Supplier	Origin Country	Origin port	Destination port	Origin loading & trucking (weeks)	Quay-quay sailing / door-door trucking time (weeks)	Delivery to UK warehouse (weeks)
Example 1	USA	Norfolk	LGW	1	3	1

this is the info on the other sheet. and what I am trying to achieve is:

Origin port	Dest port	Requested Ex Factory WK	Requested Ship WK	Requested UK Port WK	Requested Delivery WK	Requested Ship Date	Requested UK Port Date	Requested Delivery Date
Norfolk	LGW				Insert week		=requested delivery date-3 weeks sailing time pulled through from other sheet (quay-quay value)	=requested delivery week in date format