Help need on returning data with three variables

Hi,
I need to find a way to return a variable for column J in the attached. The issues I am having is the fact that the data is dependent on the 3 variables in column A-C and I would like to return the appropiate value in column D dependent on the variables in columns G-I, interpolated or otherwise.

So far I have tried to concatenemat the variables and the do a vlookup, but this doesn't work as there are different bank names. Also I am not able to name the brange as the dfata in A-C will be dynamic and change for day to day.

Any suggestions or help will be really appreciated.

Thanks,

Michael