mardi 4 juillet 2017

Excel if Function,select cell in line with match

Here is my problem .

I have an excel workbook with 2 sheets with the same fields but different amount of records. Both sheets have an ID field and date field.

If the ID from column a of sheet 2 exists in column a of sheet 1 then I want to use the date field from sheet 2 to populate the date field in sheet 1 for that matching ID.

Please help me figure this out. I can post sample data.

Thank you

Aucun commentaire:

Enregistrer un commentaire