Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I am using VLookup but getting some strange results. Although the data matches some return #N/A. Please look below for examples. Why is this please?
Excel Workbook | ||||
---|---|---|---|---|
D | E | |||
44174 | 17708670000056 | #N/A | ||
44175 | 17708670000056 | #N/A | ||
44176 | 17708670000056 | T5_MPV_178_4WD | ||
44177 | 17708670000056 | T5_MPV_178_4WD | ||
44178 | 17708670000043 | #N/A | ||
44179 | 17708670000043 | #N/A | ||
44180 | 17708670000043 | T5_ALL_84_FWD | ||
44181 | 17708670000043 | T5_ALL_84_FWD | ||
44182 | 17708670000044 | #N/A | ||
44183 | 17708670000044 | #N/A | ||
44184 | 17708670000044 | T5_ALL_101_FWD | ||
44185 | 17708670000044 | T5_ALL_101_FWD | ||
Sheet1 |