I want to compare cells in differnet sheets to match the content and then copy a field into the other sheet if true.
Sheet 1 Sheet 2
Job No Name Job No Name
123 123
456 789
If job number in sheet 1 matches job number in sheet 2 then copy Name form sheet 2 to sheet 1, if not match leave blank.
Any help would be appreciated.
Sheet 1 Sheet 2
Job No Name Job No Name
123 123
456 789
If job number in sheet 1 matches job number in sheet 2 then copy Name form sheet 2 to sheet 1, if not match leave blank.
Any help would be appreciated.