Need to search an excel spreadsheet column

Closed
heyhere Posts 2 Registration date Wednesday 13 January 2016 Status Member Last seen 13 January 2016 - 13 Jan 2016 à 09:03
heyhere Posts 2 Registration date Wednesday 13 January 2016 Status Member Last seen 13 January 2016 - 13 Jan 2016 à 10:24
but hoping I'm wrong?

Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cell (say D5) then want to add text in the cell directly above this one (say D4) with the text "1 Pounds" At the same time want to change the text in the same row but different column (say B4) with the text "Simple"
Related:

1 response

heyhere Posts 2 Registration date Wednesday 13 January 2016 Status Member Last seen 13 January 2016
13 Jan 2016 à 10:24
I just learned that I cant use formula in same column I'm searching...here's a modified question:

Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cell (say D5) then want to add text one column over in E4 with the text "1 Pounds" At the same time want to change the text in the same row but different column (B4) with the text "Simple"