Conditional format using formula that contains VLookup

[anrichards22]

I have a set of data in A:P
I have a named range "TR" in which I need to look up a value

I would like to conditionally format Columns M:P if the value in the cell is less than a value in the lookup table
Column M corresponds with the 2nd column of the lookup table
Column N corresponds with the 3rd column of the lookup table ETC

My formula would be:

if M2 < Vlookup(b2&g2,TR,2,false) then conditional format
if N2 < Vlookup(b2&g2,TR,3,false) then conditional format

etc for Columns O and P

I have attached a sample workbook.
Any assistance appreciated.

Thanks again.

[FDibbins]

Try this as a"use formula" new rule in CF...
=M2<VLOOKUP($B2&$G2,$D$22:$H$27,MATCH(M$1,$D$21:$H$21,0),0)

[anrichards22]

FDibbins,

The formula does not work.
Can I ask what the purpose of the "match" function is? Why can't it just be 2?