jmcgillis14
New Member
- Joined
- Sep 24, 2014
- Messages
- 12
A | B | C | D | |
1 | Name | Number | Name | Number |
2 | Alex | 15 | Sarah | 45 |
3 | Eric | 20 | Steve | 33 |
4 | Steve | 33 | ||
5 | Seth | 33 | ||
6 | Sarah | 45 | ||
7 | Erica | 50 |
<tbody>
</tbody>
I need to be able to Search Column A, find a Match for column C. Once that Matches, I need to Fill Column D with the same number to the right of the cell that matches. For example, if I type in Sarah in C4, I need D4 to bring me back 45. If I typed Alex into C3, D3 needs to return 15.
Thank you for your help.