Need to search an excel spreadsheet column

Closed
heyhere Posts 2 Registration date Wednesday January 13, 2016 Status Member Last seen January 13, 2016 - Jan 13, 2016 at 09:03 AM
heyhere Posts 2 Registration date Wednesday January 13, 2016 Status Member Last seen January 13, 2016 - Jan 13, 2016 at 10:24 AM
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 January 13, 2016 Status Member Last seen January 13, 2016
Jan 13, 2016 at 10:24 AM
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"
0