LOOKUP Column and Row to return value

[nathanexcelhelp]

I have a table with financials contained within it (tab 'deductible table'). A year for each row and columns for each area and then values against each.

I wish to look up the area column and the corresponding year and return the value within the table.

Column D, G, H contain formulas to work out their values.

For the value in column I, i wish to look at the Year in column D and the Cover in column G to return the corresponding value in the deductible table tab.

I think it might be an index and match function perhaps but im not sure how to do this.

Thank you

[AliGW]

In I3 copied down:

=INDEX(Table2[[Employers Liability]:[Property]],MATCH([@[Year Cal]],Table2[Year],0),MATCH(G3,Table2[[#Headers],[Employers Liability]:[Property]],0))

[Ash_Maverick]

I added the formula in column I in the sheet named 'Data'

What else do you want?

[samba_ravi]

or
I3=

Please Login or Register  to view this content.

[nathanexcelhelp]

It doesn't like something somewhere

Error message

'The name that you entered in not valid'

[AliGW]

You have been given several solutions: which one doesn't it like?

[nathanexcelhelp]

Ash Mavaricks worked. Thank you all