VLOOKUP question

goodmachine

Board Regular
Joined
Oct 7, 2009
Messages
70
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.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top