Oct 28 2019 01:47 AM
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 selected one.
For Example for the phone bill I would like to search column J for text "A1" and if there is such cell to copy the value of the previous cell which is "10" to the one I need - C4
I saw something similar in the below thread:
Could you please help?
Oct 28 2019 03:40 AM
SolutionYou 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:
Oct 28 2019 05:06 AM
@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"?
:)
Oct 28 2019 05:24 AM
Oct 28 2019 03:40 AM
SolutionYou 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: