I have a table I am trying to pull info from for another table and I think the index match function is the way to do it but I am having trouble with the formula. what I would like to accomplish is for the respected unique identifier ("BASE") to populate the coupon if the maturity is in the respected range above. Hopefully someone can easily help out here
Data Table:
BASE CUSIP Issue Coupon Maturity
66612A 66612ABH0 Northfield Bk Staten Is N Y 0.55 5/12/2017
06426W 06426WCA8 Bank Of China New York City Brh 0.75 5/19/2017
05580A 05580AHG2 Bmw Bk North Amer Salt Lake City 0.55 5/22/2017
66612A 66612ABH0 Northfield Bk Staten Is N Y 0.75 6/10/2017
06426W 06426WCA8 Bank Of China New York City Brh 0.75 7/7/2017
Table #2:
5/3/2017 6/3/2017 7/12/2017
5/23/2017 6/23/2017 7/22/2017
BASE
66612A 0.55 0.75 -
06426W
Bookmarks