I need a formula that will compare a name from a google sheets column C, tab "interaction_extract", with name lists in column T of tab "BTA". If the name from the first cell matches any of the names, separated by ";" throughout column T from the BTA tab, then the row associated name in column D of tab BTA should be migrated to column B from the interaction_extract tab. The formula should be implemented in column B of the interaction_extract tab. Basically, I need to compare a verbatim name with a list of synonymns on another tab, to populate that row with a valid name. For an example, on tab interaction_extract cell C3102, the name says "Thomas's fruit-eating bats". This name matches one in the list from T55 on tab BTA, so the name "Dermanura watsoni" found in D55 of tab BTA should be migrated to B3102 on tab interaction_extraction.
jhpoelen
commented
1 year ago
I need a formula that will compare a name from a google sheets column C, tab "interaction_extract", with name lists in column T of tab "BTA". If the name from the first cell matches any of the names, separated by ";" throughout column T from the BTA tab, then the row associated name in column D of tab BTA should be migrated to column B from the interaction_extract tab. The formula should be implemented in column B of the interaction_extract tab. Basically, I need to compare a verbatim name with a list of synonymns on another tab, to populate that row with a valid name. For an example, on tab interaction_extract cell C3102, the name says "Thomas's fruit-eating bats". This name matches one in the list from T55 on tab BTA, so the name "Dermanura watsoni" found in D55 of tab BTA should be migrated to B3102 on tab interaction_extraction.