I have tried using vlookup for this but it is not returning the currect field. I have two different excel files. I need to compare phone numbers from one column in file 1 to all of the different worksheets column C in file 2. If file 2 has the same phone number from file 1, then copy the entry from column L on that row to column F in file 1.
More clarification:
File 1:
Compare all phone numbers in column A to column C in all worksheets in File 2.
File 2:
If a matching phone number is found from column A in file 1 and any column C in file 2, then copy the number in column L on the same matching row from file 2 into the same matching row of the original phone number in file 1 into column F.
Let me know if there is a function that will do this or if you need more clarification.
Thanks!
Bookmarks