The sniper instructor is correct as long as you're trying to keep things simple, with constant wind, at a "television viewer" level.
The slower the bullet moves, the more effect the wind has on it.
Think about it as if the bullet is trying to swim across a river with a fast current flowing. If the bullet moves fast, the current only carries it downstream a small amount before it reaches the opposite bank. If the bullet moves slowly, the current will carry it downstream a great distance before it reaches the opposite bank. The slower the bullet moves, the more effect the current has on it.
As a rough estimate you can use the "Rule of Squares". For instance, many people think that in a constant wind, if a bullet drifted 1" at 100 yards, it would drift 2" at 200 yards, 4" at 400 yrds, 6" at 600 yards, etc. In reality, you need to square the distance difference to approximate the wind drift. For instance, a bullet drifts 1" at 100 yards and you want to know how far it would drift at 600 yards. Since 600 is 6 times 100, you square the distance difference. 6x6 =36 so the bullet will drift about 36 times the distance it did at 100 yards, or 36".
If the bullet drifted 5" at 300 yards, it would drift about 20" at 600 yards. 600 is 2 x 300, 2x2=4, 4x5"=20"
You can see the difference in this wind drift chart for a 6mm BR:
For instance, if it has about 2.5" of drift at 200 yards, then by the rule of squares at 400 it'll have 2x2=4, 4x2.5"= 10". You can see how this agrees with the chart.
There's a longer explanation here:
http://www.6mmbr.com/winddrift.html
Sierra has a section on wind in the back of their manual, they have most of it online here. Unfortunately, the charts aren't online.
http://www.exteriorballistics.com/ebexplained/4th/532.cfm