The file that I need help with appending can be downloaded here: http://www.susanramsey.net/APPEND-MAIN FILE.xls
The phone numbers in the APPEND sheet are also found in the MAIN sheet. I need to pull the data in the MAIN sheet over to the APPEND sheet...and have it match up by matching the phone numbers...so the END results produces data that has all the fields from the MAIN file in the matching rows that correspond with the same phone number in the APPEND file...and also have the Date/Time info in the appropriate rows.
I sure could use some specific instructions on how in the world to do this. I have watched the video at http://www.youtube.com/user/ExcelIsFun#p/search/28/AeYOODc-Ejs several times now and used the =VLOOKUP(A4,L$4:M$8,J4:M4,0 however keep getting a #REF error.
Thanks for any help!
The phone numbers in the APPEND sheet are also found in the MAIN sheet. I need to pull the data in the MAIN sheet over to the APPEND sheet...and have it match up by matching the phone numbers...so the END results produces data that has all the fields from the MAIN file in the matching rows that correspond with the same phone number in the APPEND file...and also have the Date/Time info in the appropriate rows.
I sure could use some specific instructions on how in the world to do this. I have watched the video at http://www.youtube.com/user/ExcelIsFun#p/search/28/AeYOODc-Ejs several times now and used the =VLOOKUP(A4,L$4:M$8,J4:M4,0 however keep getting a #REF error.
Thanks for any help!
