So I'm trying to take the value found in Sheet 1 starting at A2. Switch to sheet 2 and Check Columns A & B to see if it finds a match. If it does then it will take the information from column c on sheet 2 and place it in column b on Sheet 1. If it doesn't find a match it will then just move onto the next one. The example I have given shows the beginning information on Sheet1 and Sheet2 and the final result is shown on Sheet3 and Sheet4. Any help is desperately needed. Thanks again.Test.xlsx
Bookmarks