complex if with index & match formula based on criteria in a column to extract data

[JEAN1972]

I have workbook with 2 sheets Database tax code and calculation sheet.

On calculation sheet column O header general rate % I am looking a formula to extract from database tax code General % column E, the criteria is

column A2 of calculation sheet which has to lookup in database tax code column B, if they both match then extract the corresponding rate applicable, but

the most difficult part is the column N preferential code of calculation sheet that if there is an imput in this column that is SADC as example then extract the corresponding rate of column L based on column B of database tax code .

then same principle applies if it is one of these code tax applies to COMESA1,COMESA2, SADC, IOC, INDIA, PAKISTAN, EC, TURKEY. then put the corresopnding rates , If column N of calculation sheet is blank then applied normal rate of column E of database code

[JohnTopley]

In O7

=IF($N2="",VLOOKUP($A2,'DATABASE TAX CODE '!$B$3:$Q$55,4,0),VLOOKUP($A2,'DATABASE TAX CODE '!$B$3:$Q$55,MATCH('Calculation Sheet'!$N2,'DATABASE TAX CODE '!$B$1:$Q$1,0)))

Or

=VLOOKUP($A2,'DATABASE TAX CODE '!$B$2:$Q$55,MATCH(IF($N2="",$O$1,$N2),'DATABASE TAX CODE '!$B$1:$Q$1,0))

Change "O1" to "General %"

[JohnTopley]

Additional formula in previous post

[JEAN1972]

Thank you John I prefer the second option the formula more simple

Works smartly

Kinds Rega

[JohnTopley]

You're welcome. And thank you for the rep.