Google Sheets Formula

Krouton000 - Jun 23, 2022 at 07:08 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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,"")

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
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