Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
When I try using VLookup each result gives #N/A. The format of the numbers are like:-
The numbers on the left are on both files but I don't get the numbers on right on the destination file just #N/A? I have gone to file, options, format and checked it is set to automatic? I have been using VLookup for years and know how to do it,
122213 | M15707430247002 |
122218 | M15707430247003 |
122219 | M15707430247004 |
The numbers on the left are on both files but I don't get the numbers on right on the destination file just #N/A? I have gone to file, options, format and checked it is set to automatic? I have been using VLookup for years and know how to do it,