How to make formulas if, in exl, take values ​​from one page, find what they are equal to on another page?

Question

excel

It is necessary to split the values ​​​​from one cell on one page, find if they are on another page, and if there are, then take their values ​​\u200b\u200band write them into a formula (not each specific one, but through an array)

sh = wb.sheet_by_index(1)
result3 = list( map(str, object.split()))

sh = wb.sheet_by_index(1)
value1 = sh.cell(i, 6).value
object2 = sh.cell(i, 4).value

if (object2 == object) :
result1 = 'text' + value1


We want the result to be displayed like this:

result1 = 'text' + testpass1 + testpass2 + testpass3