I have a list of leads that have everything but the phone number and then a list with everything.
List A (lista.csv) has Name, Street, City, Zip, Age
List B (listb.csv) has Phone Number,Name, Street, City, Zip

what I want to have is
List C (listc.csv) Phone Number,Name, Street, City, Zip, Age

so I need a vba or method to have workbook C open List A and scan through list B to match Street & Name and if those two conditions match to take the phone number data from list b and add it to the correct record from list A and save it as List C.