goodmachine
Board Regular
- Joined
- Oct 7, 2009
- Messages
- 70
Hello,
When I run my VLOOKUP to match values from one sheet to another, the Table_array consists of data where the values are stored as text. The values on the Table_array can be numbers only or alphanumeric. Some of the numbers have leading zeros as well.
When I run the VLOOKUP, the formula is unable to match the Lookup_value. For example, the Lookup_value can be 131112 and that value is on the Table_array, but the formula result will be #N/A. Only when I convert the value to a number will the VLOOKUP return 131112.
I've tried a couple of things to get passed this issue:
1. Format Cells to General
2. Copy the Table_array and Paste as Values.
3. Defined the table
None of these changes have not improved the results.
Any help is appreciated.
Thank you.
When I run my VLOOKUP to match values from one sheet to another, the Table_array consists of data where the values are stored as text. The values on the Table_array can be numbers only or alphanumeric. Some of the numbers have leading zeros as well.
When I run the VLOOKUP, the formula is unable to match the Lookup_value. For example, the Lookup_value can be 131112 and that value is on the Table_array, but the formula result will be #N/A. Only when I convert the value to a number will the VLOOKUP return 131112.
I've tried a couple of things to get passed this issue:
1. Format Cells to General
2. Copy the Table_array and Paste as Values.
3. Defined the table
None of these changes have not improved the results.
Any help is appreciated.
Thank you.