lookup based on 2 criterias

[Zalabya83]

Hello,

i’m trying to return the value of a product and need it to be dynamic once i change the month in drop down list that reads from another sheet.

dates in month/years are in horizontal order btw with the values under it in a specific row in the table

any ideas how to solve this please

 

[kweaver]

Why won't you show a few examples of your data and expect results? Please use XL2BB when you do.