Want Fill blank cell values with left cell values if condition matches

amittheexcel

Board Regular
Joined
Dec 17, 2013
Messages
50
Hi,

I have below scenario, I want to fill Clean data column with Source data if clean column do not have values only if first column data is matching after source and Clean.

Source_Account_NameClean_Account_Name
Amit ChavanAmit Chavan
Amit Chavan
Amit Chavan AAmit Chavan A
Amit Chavan AAmit Chavan A
Amit Chavan
Amit ChavanAmit Chavan A

<tbody>
</tbody>
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
What is expected output in : Clean_Account_Name

is it:
Amit Chavan
Amit Chavan
Amit Chavan A
Amit Chavan A

Amit Chavan A

So second row filled with left column, 5th left empty because in first column row 4 and 5 values are different
 
Upvote 0

Forum statistics

Threads
1,215,734
Messages
6,126,543
Members
449,316
Latest member
sravya

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
Back
Top