Macro to iterate vlookups

[franciscocorrea]

Hello everyone!

I have the following problem: I want to find the parent value for each account, as you may see on the following example:

Account Parent Column C
1
11
11111
121
1211
12111111

I want the VBA to find the parent value of each Account and type it on Parent column. To do so VBA should remove one digit from each Account entry and then make a vlookup to see if that resulting number exists on column Account. When vlookup finds the number it is the parent. In case vlookup doesn't find the number it should keep on removing digits until it finds.


So the expected result is:


Account Parent
1
11 1
11111 11
121 1
1211 121
12111111 1211

I hope I made my self understood...

Many thanks!!

Best

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...l-basic-applications-looping.html#post3663932

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).