I am trying to lookup data from two concatenated colums and retrieve data
from a pivot table where the column & row matches the concatenation, return
the max value in the pivot table. Below is my example data:

Pivot Table
Max of Value
Column Row Total
AB_N AB
AL 1.25
AR 1.15
AZ 1.62
BC
CA 1.25
CO 1.95
AL_N AB 1.95
AL 3
AR 1.75
AZ 1.65
AL_S AB 1.95
AL 3
AR 1.75
AZ 1.65

I want to retreive the max value where the concatenation of the below table
matches matches the column and row in the below table.

Table
O Region D State Concatenation
AR_N FL AR_NFL
PA_E GA PA_EGA
VA_E WA VA_EWA
VA_E TX VA_ETX
VA_E FL VA_EFL

Can anyone help?