Share via

find text in an array

Anonymous
2024-12-25T16:14:16+00:00

find a word in an array, if yes then copy value from a cell

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-12-25T23:24:20+00:00

    Hi,

    Would you bother to share some data and show the expected result. Share data in a format that can be pasted in an MS Excel file.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-12-25T17:05:00+00:00

    Could you share some dummy data and show expected result? Then I can give formula suggestions on it.

    Here is a formula to find "ABC" in array A2:A4, if found, it will copy value from C2 to D2.

    =IF(OR(A2:A4=B2),C2,"Not found")

    Here is another formula which will find E2 in A2:A4 and return value from B2:B4.

    =XLOOKUP(E2,A2:A4,B2:B4)

    Was this answer helpful?

    0 comments