Hi!
I have a topic in which I need some help:
I need a formula to check if a cell's value/text can be found in another sheet/workbook. It needed to be checked for the entire column in each workbook because the data quantity can change dynamically. If the value/text can be found in the other database, then the formula must copy the text from another cell ("NOTE") in the same row as the data found.
Example for the database to where I have to place the formula:
Example for the database where value/text needed to be searched:
In real life the "NOTE" is not in the column next to "CODE" but for like 20 columns to the right and there is several more columns filled with data between them.
Thanks for the help in advance!
I have a topic in which I need some help:
I need a formula to check if a cell's value/text can be found in another sheet/workbook. It needed to be checked for the entire column in each workbook because the data quantity can change dynamically. If the value/text can be found in the other database, then the formula must copy the text from another cell ("NOTE") in the same row as the data found.
Example for the database to where I have to place the formula:
Example for the database where value/text needed to be searched:
In real life the "NOTE" is not in the column next to "CODE" but for like 20 columns to the right and there is several more columns filled with data between them.
Thanks for the help in advance!
Last edited by a moderator:
