Hi there,
i have the following database
| Installation | OdS 11 | OdS 12 | OdS 13 | OdS 21 | OdS 22 | OdS 23 | OdVr1 | OdVr2 | OdVr3 | Input_#3_Materials needed date | Info |
| Plant A | | | | 7110000730 | | | 4000012979 | | | 01/05/2024 | |
| Plant B | 7110000960 | | | | | | | | | 01/05/2024 | |
| Plant C | 7120001238 | | | | | | | | | 01/05/2024 | |
| Plant D | | | | 7110000688 | | | | | | 01/05/2024 | |
| Plant E | | | | 7120000883 | 7120001183 | | | | | 01/05/2024 | Info AAA |
I would like to search for a value in the second column (similar to a VLOOKUP) within a specified range of the above database (from OdS 11 to OdVr3) and retrieve the corresponding information to populate the second database, appending several columns; in this case, it’s only the ‘info’ column, but there are additional ones.
| Installation | SAP | TARGET DATE | Info |
| Plant E | 7120000883 | 01/05/2024 | Info AAA |
| Plant D | 7110000688 | etc. | etc. |
The issue is that I don’t know in which cell (from OdS 11 to OdVr3) the SAP value will be
many thanks for your help!
