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!