I have information in Sheet 1 that I need to add to sheet 2. I am unable to get a formula that helps with this so I am wondering if anyone knows. I have very limited knowledge of the vlookup function.
Issue:
Sheet1 : Column A = Group Number; Column B = Group Name
Sheet2: Column A = Group Number
I need to replace the group number with the correct group name on Sheet 2. So where column A number on sheet 2 is equal to column A number on sheet 1, replace value on sheet2 column A with Name populated in column B from sheet1. So basically a mass "find and replace" option through a formula.
Any help would be greatly appreciated!!
Bookmarks