match 3 cells and show third

Hello,

 

I am trying to write a formula that will work with the following:

If we say that 'product' is cell A1

 

Product	Client	Jul	Aug	Sept	Oct	Nov	Dec
ORANGE	JOHN	10.000	20.000	30.000	40.000	30.000	20.000
		10.000	20.000	30.000	40.000	30.000	20.000
LEMON	PETER	11.025	25.315	56.215	33.330	24.521	26.631
		11.025	25.315	56.215	33.330	24.521	26.631
LIME	PAUL	34.000	34.525	62.542	36.221	32.525	21.215
ORANGE	PAUL	10.000	20.000	30.000	40.000	30.000	20.000
		44.000	54.525	92.542	76.221	62.525	41.215

 

I have another workbook:

If we say 'client' is cell A1

 

Client	paul	product	lime
	jul	aug	sept	oct	nov

 

I need to match the first table with the second to show the value for the month, for paul and lime.

 

so in this instance, in cell B4, i would like to insert the formula to show, that if A2= paul and A4 = lime show the value that corresponds with B3 (jul) from the other table = 34000.

 

apologies about the terrible explanation.