lookup and changing cell

Rip1971

Board Regular
Joined
Nov 3, 2020
Messages
60
Office Version
  1. 365
Platform
  1. Windows
Hi all,

i am looking for a script that dows the following.

lookup in all rows of column X if the cell contains text "xyz" then change the value of row/cell in kolom Y

i know i am using generic values but i have multiple values to be looked up and changed

hope that this makes al little sense.

kind regards and thanks in advance for helping

Rip.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Automatrix

Active Member
Joined
Aug 15, 2022
Messages
274
Office Version
  1. 365
Platform
  1. Windows
Power Query solution: Conditional column - If [X] equals "xyz" then (new value) else [Y]. Delete old column Y.
 
Upvote 0

Forum statistics

Threads
1,186,710
Messages
5,959,313
Members
438,412
Latest member
jldccc2007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top