Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,751
- Office Version
- 365
- Platform
- Windows
I have sheet 2 with a list of numbers in column A. I need a code please that will look for these numbers on sheet 1 in column AD and put the number that is next to it in column B on sheet 2 in the cell directly below in column Ad on sheet 1. Thanks.
Sheet 1 Before
Sheet 1 After. I have highlighted the cells where the data has been added.
Thanks.
Excel 2010 | ||||
---|---|---|---|---|
A | B | |||
1 | ||||
2 | Test | Test1 | ||
3 | Data | Data1 | ||
Sheet2 |
Sheet 1 Before
Excel 2010 | |||
---|---|---|---|
AD | |||
2 | Test | ||
3 | NYA | ||
4 | NYA | ||
5 | Test | ||
6 | NLA | ||
7 | Data | ||
8 | NYA | ||
9 | NYA | ||
10 | NYA | ||
11 | NYA | ||
12 | Data | ||
Sheet1 |
Sheet 1 After. I have highlighted the cells where the data has been added.
Excel 2010 | |||
---|---|---|---|
AD | |||
2 | Test | ||
3 | Test1 | ||
4 | NYA | ||
5 | Test | ||
6 | Test1 | ||
7 | Data | ||
8 | Data1 | ||
9 | NYA | ||
10 | NYA | ||
11 | NYA | ||
12 | Data | ||
13 | Data1 | ||
Sheet1 |
Thanks.