Hi all! I strugle with my project. I don`t know how to make a formula, whitch could retrieve a value from one of many worksheets and when two criterias given. Example: there are 31 sheets for days of the month and one for graphs. So, in graphs there are two cells with the data validation. In one of them you pick a product, and in another pick a day. And I want to be able to get a value from the specific sheet and product. So, what formula I have to use?
Bookmarks