VBA-Advanced Lookup functions

I have a tough example that I can't solve and I'm not sure if it can be solved. I'm in need of a formula or macro to lookup values in another file.

Directions:
1. Open Lookup file (attached). What's in yellow is the answer guide. I would like to have a formula or macro to lookup the values in DSMP file (attached) and return the same values that I have currently in yellow. Lookup basically by promo, Base SRP/LUCP, & March.
2. I can't change DSMP file (columns, rows, merged cells etc). I want to keep this file as is.

Anybody have any ideas? It would be greatly appreciated.