Hi
I used wolverineb’s formula
http://www.mrexcel.com/forum/showthread.php?t=458054&highlight=wind+direction) in reverse to calculate the wind direction in degrees from wind direction in text.
The lookup table is
This works well after a little tweaking.
The formula I am using is...