Search for a value in multiple cells

[Guglielmo91]

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!

[adamweaver39]

Hey @Guglielmo91 ! I think I found a solution to create that connection between your two tables. See attached workflow and let me know if that does the trick. 

[Qiu]

@Guglielmo91 
I will do the same as @adamweaver39 

[adamweaver39]

That is a big affirmation coming from the master, @Qiu!

[Qiu]

@adamweaver39 
I am flattered. 😁