I need to return values from Sheet2!B1 where the string in Sheet2!A1 partially matches the string in Sheet1!A1. I have 3000 rows of random letters and numbers in A1 with the corresponding logical data in column B1
IE:
Sheet1!A1 = aslkdjfaslkjjjj
Sheet2!A1 = faslkjjj
Sheet2!B1 = realdata
I need to populate Sheet1!B1 with the real data contained in Sheet2!B1 where Sheet2!A1 partially matches the string in Sheet1!A1
This is confusing but I'm not sure how else to explain it.
If I understood what you want, there's a way to do it with a helper column:
1) In Column C of Sheet2, use the following formula:
=IFERROR(MATCH("*"&A1&"*",Sheet1!A$1:A$3000,0),"")
And populate down
2) In Column B of Sheet1, use the following formula:
=IFERROR(INDIRECT("Sheet2!B"&MATCH(ROW(B1),Sheet2!C$1:C$3000,0)),"")
And populate down
Note: if this is the correct solution, then please edit your question with the added info, it will make it easier for others to find it
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments