Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

Hi all,

I need a simple formula (not array formula) like SUMIFS, COUNTIFS, etc for multiple Vlookups..

Herewith I attached sample excel file, anyone pls help me..

Thanks

I have two inputs 1. Project name 2.Date of billing;

If I enter project name is "Project A" & date is 01/10/2012 the result should be "Exempted" (Mentioned in master data Project A is Exempted from 01/07/2012 to 31/03/2015)

and in case I enter date from 01/04/2015 to 17/11/2015 the results should be "Taxable" (Mentioned in master data Project A is Taxable from 01/04/2015 to 17/11/2015)

Working Perfect, Thank you so much..