Google Sheets Formula

Krouton000 - Jun 23, 2022 at 07:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 27, 2022 at 11:50 AM
I need to search column D for "Text 1", then if its true, any row that has it, take the data in column B(same row) and enter it into another cell. for example,

D14, includes "Text 1, Text 2, Text 3", so since it includes "Text 1", then "Lesson 1" from B14 goes in F2

neither of these are working (yes, I am retrieving from another sheet labeled INFO)
=VLOOKUP(A3,INFO!$B$4:$D$88,1)
=IF(INFO!D4:D88="Text 1",INFO!B4:B88,"")
Related:

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Jun 27, 2022 at 11:50 AM
Hi Krouton,

Give the following formula a try:
=IF(ISERROR(SEARCH("Text 1",D2)),"",B2)

Does that solve your query?

Best regards,
Trowa
0