1

Essentially I'm trying to figure out a formula that checks if Column A has the string "example", then grab the data in the corresponding row for Column B.

So if A1 says "Example" grab B1 data but I need to do this for multiple rows at the same time if possible.

2
  • What have you tried so far? "New to this website, sorry if this isn't how you ask questions" Please read the help to find more info. May 6, 2020 at 7:53
  • This question has been bumped by Community user 12 times. Oct 27, 2023 at 21:53

2 Answers 2

0
Column A   | Column B | Column C
My example | 100      | =IF(ISERROR(FIND("example",A1)),"",B1)

FIND function is case-sensitive. If you want a case-insensitive search you should use SEARCH function.

If your string can vary, you can place it in cell D1, for instance and reference to it:

=IF(ISERROR(FIND($D$1,A1)),"",B1)

If the string is variable per row, add a third column

Column A   | Column B | Column C | Column D
My example | 100      | example  | =IF(ISERROR(FIND(C1,A1)),"",B1)
0

In C1 enter:

=filter(A1:B6,A1:A6="example")

enter image description here

make the "6" whatever you need.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.