MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
Fropm this list - I need to confirm if the numbers in column D appear in column A, result in E
Whats the best way? Vlookup?
TIA
HAMMONDS - FA.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 144482 | MrDavidMead | Reference | ||||
2 | 159956 | MrReubenStevens | 144482 | ||||
3 | 170908 | MrRobertMullett | 174653 | ||||
4 | 173722 | MrsIreneNicholson | 219833 | ||||
5 | 174653 | MrsLisaPark | 245826 | ||||
6 | 175150 | MissLeanneWheater | 288328 | ||||
7 | 181242 | MrCraigNewman | 311779 | ||||
8 | 187837 | MrsCatherinePayne | 313089 | ||||
9 | 188463 | MrStephenHunt | 331670 | ||||
Sheet1 |
Whats the best way? Vlookup?
TIA