I hate asking this because I know I will feel dumb when I see the answer but here goes:
I have data in 2 worksheets of 1 workbook. Column B of each worksheet contains the data that I want to match. Wherever there are rows with a match in the B column of each, I want to pull the data from Sheet 2, Column D, and merge it into Sheet 1, Column F. Hope I explained this well enough for someone to help.
Thanks.
I have data in 2 worksheets of 1 workbook. Column B of each worksheet contains the data that I want to match. Wherever there are rows with a match in the B column of each, I want to pull the data from Sheet 2, Column D, and merge it into Sheet 1, Column F. Hope I explained this well enough for someone to help.
Thanks.