vendredi 8 septembre 2017

Cross Reference Column A Sheet 1 w/ Column A Sheet 2 to give column c,d,e

Cross Reference Column A Sheet 1 to find a matching value on Column A Sheet 2, and then fill in corresponding Column B, C, D Values from Sheet 2 for Sheet 1.

I have 2 sheets:

Sheet 1: Company & Representative Sheet 2: Company & Client first name, Client Last Name, Client Email

I want to match to put in new columns on Sheet 1 that have the client first name, last name, and email based on the company matching ( they do not match by cell #).

Does anyone have any advice on how to do this? I've got about 2000 and know there must be a better way than manual.

Thanks so much! Kalina

Aucun commentaire:

Enregistrer un commentaire