Thread: Lookup Formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
abcdexcel
 
Posts: n/a
Default Lookup Formula


Sir,

The rates do not overlap.

For each product, there is a different rate for various period.
Secondly, the rate also depend on the place selected in cell B2.

Thus, the formula should first identify the place, then identify the
product code, then identify the date and return the sales tax rate from
the table.

Thanks & Regards,
New Excel User


--
abcdexcel
------------------------------------------------------------------------
abcdexcel's Profile: http://www.excelforum.com/member.php...o&userid=30021
View this thread: http://www.excelforum.com/showthread...hreadid=497118