Hi
I need a formula to bring back a cost based on a date and category. The categories have two costs between a different range of dates. I have attached an example to help explain.
I tried =lookup formula but it didn't work, it seemed to stop at the first cost amount from the category it found.
I would appreciate any help.
Thanks
Bookmarks