Formula - adding an IF Query onto vlookup query

Please see attached





Hi all, I have a rather a tricky one today..[for me anyway]... please see tab 'PSF', columns B and C

You will see a simple v-lookup table based on column D

The problem is this:
I need something to look at column F, and if the letters 'HGV' appear at all in this column then in overrides the values in columns B&C

So if 'HGV' appears in any way or form in column F then column B overrides the vlookup table and becomes the value "Maltby Substitute" and column C overrides the v-lookup table and becomes "Drax". I somehow need to add this in without damaging the existing formula.

Any ideas guys?

Thanks very much indeed in advance for any help,

M