Forum Discussion

krisi042's avatar
krisi042
Copper Contributor
Oct 28, 2019
Solved

Check column for specific value, and if its found, copy the value of the previous cell

Hello,    I`m doing some expenses calculation and I was wondering if there is a way to search for specific text in a column and if it finds that text to copy the value of the previous cell to the s...
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Oct 28, 2019

    krisi042 

    You may store your search text in A4, then enter this formula in C4: 

    =LOOKUP(2,1/(
    ISNUMBER(SEARCH(A4,J$6:J$12))),
    I$6:I$12)

    The foregoing formula shall return 10, as shown below: 

Twifoo's avatar
Twifoo
Silver Contributor
Oct 28, 2019

krisi042 

You may store your search text in A4, then enter this formula in C4: 

=LOOKUP(2,1/(
ISNUMBER(SEARCH(A4,J$6:J$12))),
I$6:I$12)

The foregoing formula shall return 10, as shown below: 

  • krisi042's avatar
    krisi042
    Copper Contributor
    Oct 28, 2019

    Twifoo it works very well for me 🙂 Thank you .

     

    In addition do you think I can add multiple values in A4 cell? 

    for example "A1"; "A2"?

    🙂

     

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Oct 28, 2019
      I suggest you store additional search text in another cell.

Resources