Questions:

1 - It looks like each column has its own time frame, meaning that the
start and end date of one column don't overlap the start and end date
of the previous or following columns, is that the case?

if that is the case then a lookup on just the date alone would do,
using an HLOOKUP formula.

=HLOOKUP(B1,D14:I18,???,1)


2 - How is the tax rate determined? In your example a tax rate of
12.50%, 15.00% or 10.00% is possible, what percentage should be
returned?

need more details.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497118