Good morning,
I need the help to solve a problem.
I have a table 1 with the following information:
Table 1
Supplier Initial Date Final Date Value
A 15/10/2022 20/10/2022 Madrid
A 01/10/2022 14/10/2022 Barcelona
B 10/10/2022 29/10/202 Zaragoza
B 01/10/2022 09/10/202 Sevilla
What I expect is when I introduce the supplier and the date in the table 2, automatically and with a formule search the value of the table 1 depending of the intervale of dates and supplier:
Table 2
Supplier Date Value
A 19/10/2022 Madrid
A 05/10/2022 Barcelona
B 17/10/2022 Zaragoza
B 09/10/2022 Sevilla
I insert one image and example in excell to undertand better the problem.
Example.xlsx
Example Excell Image.jpg
I found one solution but only works with numeric values, not when I search one text.
Thanks in advance
Bookmarks