Excel Pros, I need your help.

[rbuff]

I really need some help from you guys that are good at excel. I am really green to excel. I know my way around it just enough to open it up. Ok, I know a little bit more but not much I swear. Here is my issue and problem.

I have 2 excel files. both contain names, phone numbers and email addresses. The diff is one file contains the current sales rep on the customer account and the other does not. I can't just sort and copy. The files are different sizes and no similar order. All the email addresses are in one column. I need excel to read col_c (email address)and col_h (sales person) in one file and col_f (email address) in the other file. If the email values from columns c and f match then insert the value from column h (sales persons name) from the first file into col_u in the 2nd file.

Does this make any sense? I edited this 4 different times.

For the life of me, I can't figure this out. I guess I'm trying to do an advanced find and replace. If you guys can offer any help, It would be greatly appreciated.

 

[BenMiller]

I really need some help from you guys that are good at excel. I am really green to excel. I know my way around it just enough to open it up. Ok, I know a little bit more but not much I swear. Here is my issue and problem.

I have 2 excel files. both contain names, phone numbers and email addresses. The diff is one file contains the current sales rep on the customer account and the other does not. I can't just sort and copy. The files are different sizes and no similar order. All the email addresses are in one column. I need excel to read col_c (email address)and col_h (sales person) in one file and col_f (email address) in the other file. If the email values from columns c and f match then insert the value from column h (sales persons name) from the first file into col_u in the 2nd file.

Does this make any sense? I edited this 4 different times.

For the life of me, I can't figure this out. I guess I'm trying to do an advanced find and replace. If you guys can offer any help, It would be greatly appreciated.

Assuming your files are named FILE1 and FILE2 (FILE1 being the one with the sales rep name). In a new column on File2, type =VLOOKUP(F1,[FILE1.xls]Sheet1!$C:$H,6,0) and drag it down all the way to the bottom of your data.

Change the filename and sheetname to match your file/worksheet.

Also, make sure that FILE1 is sorted ascending, on column C.

 

[rbuff]

Ben

It's working!!!! ****, this is awesome. Thank you so much for your help. When I first plugged in the equation it didn't work but I was moving to quickly. I forgot to sort the column in File1. Once I sorted it, it worked perfect. I'm not sure why it need to be sorted but I don't care. It's working. That was a quick response too! Thank you so much for your help.
Cheers!

 

[BenMiller]

Ben

It's working!!!! ****, this is awesome. Thank you so much for your help. When I first plugged in the equation it didn't work but I was moving to quickly. I forgot to sort the column in File1. Once I sorted it, it worked perfect. I'm not sure why it need to be sorted but I don't care. It's working. That was a quick response too! Thank you so much for your help.
Cheers!

Excel searches from the top of the email column to find a match, so it needs to be sorted; otherwise Excel gets confused!

Glad I was able to !