I am trying to write a formula to lookup an item price in the price
history table (A1:E4). I want the transaction table (A9:G11) to
pickup the correct price for the item purchased based on the date of
the transaction AND the price of the item that was effective on that
date.

In the example below, Item# 1234 had a transaction take place on
3/10/07. The pricing for the item on that date was $12. If the same
item was purchased between 1/1/06 and 2/1/07, the XLS should pickup
the $5 price.

I know that I've done this formula before but I can't remember (Its
not just VLOOKUP). Any thoughts????

ITEM_NO ITEM_DESC PRICE PR_BEG_DTE PR_END_DTE
1234 Test Item1 $5.00 1/1/06 2/1/07
1234 Test Item1 $8.00 2/2/06
12/31/07
1234 Test Item1 $10.00 1/1/08 6/1/08


Transaction Date Item_No Unit Price Quantity Sub-Total Sales Tax
Sale_Total
6/15/06 1234 $5.00
1 $5.00
5/10/07 1234 $8.00
1 $5.00
3/10/07 1234 $8.00
1 $5.00