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: 

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