Google Sheets Formula

Closed
Krouton000 - Jun 23, 2022 at 07:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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