Using DGET To Fill In Values On Whole Column

I've received a data report where the brand is in an incorrect format, but can be calculated from data in the list.

I have Brand in the format CRY, but it should be in the format CRYS or CRYW (brand + tag for winter or summer). There are other brands that behave in the same way, e.g. THO should become THOS or THOW, PLA should become PLAS or PLAW, FIN should become FINS or FINW.

I've created a new column using IF statements in conjunction with the departure date to work out whether it was a summer or winter booking, and as a result column C is now populated with either Summer13, Winter13/14 or Summer14.

I don't particularly care if it's a summer 13 or 14 booking, they get reported on together. So I now have the brand alongside the season (summer or winter). I built a database to use with the DGET formula:

Brand
Season
Result

CRY
Summer13
CRYS

[Code] ........

And I used DGET to work out what the result should be in column F:

=DGET($N$4:$P$16,"Result",B1:C2)

This works beautifully for Cell F2, but F3 can't seperate the headers (B2 and C2) from the data (B3 and C3) without tripping over B2 and C2.