Data Search and match through multiple columns and rows

[cprendergast]

Hi,

I have a table that has the following structure and data;

and i have a form that looks like this;

I need to make the form link into the table and look through the data to show the correct FIT rate depending on the selections through the form.

Everything i have tried so far doesn't work and i have drawn a blank on how to look through a table with multiple queries.

Any and all help will be very much appreciated.

ps. this is my first post here so anything missing, i do apologise and please do let me know.

Many thanks in advance,

 

[oldbrewer]

solar pv
2.7	<4
RF
01/04/2012				solar pvNB<4	solar pvRF<4	solar pvany4.1-9.9	solar pvany10-1000	heatpumpNB7
solar pvRF<4				solar pv	solar pv	solar pv	solar pv	heatpump
				<4	<4	4.1-9.9	10-1000	7
				NB	RF	any	any	NB
			01/04/2010	33	34	35	36	55
			30/09/2011	37	38	39	40	56
			01/04/2012	41	42	43	44	57
			01/08/2012	45	46	47	48	58
			42
			formula
			=OFFSET($D$4,MATCH($A$4,$D$8:$D$11,0)+3,MATCH($A$5,$E$4:$I$4,0))
		I have concatenated the headings and the input info

<colgroup><col><col span="2"><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>