Vlooup on 13 digit numbers doesnt work

Pass the crystal ball.....

Or....

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

1. It does NOT have to be your real sheet - mock up a SAMPLE if you need to. But not 1000's of rows!!! It makes manual checking so tedious. Whatever you do... make sure that all confidential information is removed first!!

2. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

3. Make sure that your desired solution is also shown (mock up the results manually).

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

ok

here is the sheet

Column B is the issue of inventory export, all the numbers that I havent clicked into and press enter are to the left margin, the ones I have are to the right and example would be row 9182 as soon as I went into the cell and pressed enter the vloopup worked.

Originally Posted by Roel Jongman

This is a common problem if data comes from another source, Excel sees the numbers as text sometimes. You can solve it in bulk with a special copy paste action..

The steps are.

1. Put a 1 in any empty cell.
2. Copy that cell
3. Select the column or range(s) that have the problematic numbers
3. Choose paste special options (so you get the menu of opyions to choose from)

4. At the bottom there is a section called "Operation" choose Multiply as the operation.
5. Click OK

now you numbers should be recognized as numbers again.

(please make sure you save the sheet or backup your sheet before trying, to prevent loss of data, it is not real difficult action but I have ended up with a column full of 1 once.)

Legend I actually just inserted another column and the multiplied original column with 1 and vlooked up the new column

Just did your multiply action and that worked perfectly, thanks guys for your help

Next time, please remember that 10-20 rows is a sample. 30,000 rows is NOT.