VLOOKUP question

[goodmachine]

I am attempting to match values from one worksheet to another. The values in Column A can be just numbers or alphanumeric. Some of the values can have a leading 0 as well. In the table array, the values can also be just numbers, alphanumeric and/or have a leading 0.

The lookup value is 2708000802. This value is in the table array and I'm expecting the VLOOKUP to return 2708000802 in column B where the lookup value is stored (where I inserted the formula). However, the VLOOKUP returns the N/A error.

• I have formatted both worksheets so that the category is GENERAL
• I have converted the 2708000802 in the table array to a number
• I have multiplied the 270800802 in the table array by 1

None of these changes have given me the result I'm looking for.

One thing to note:

• In the lookup value and the table array columns, the green diamond error appears in a lot of the cells indicating that the "cell is formatted as text or preceded by an apostrophe"

I thought by formatting the both worksheets as general, this would help.

Any help on this matter is greatly appreciated. I'm still learning about this function and how to troubleshoot the errors.

 

[markmzz]

I get the #VALUE error when I enter that formulat in cell B2.

Did you used Ctrl+Shift+Enter and not only Enter to enter the formula?

Markmzz