Excel vlookup

[brendan187]

I have two lists of data. One that has 75K accounts each with an individual ID number and the other list has 24K accounts also with their own ID numbers. I'm trying to determine how many of the 24K accounts appear on the list of 75K. The problem is that the last number on the list of 24K is incorrect for each account. I have used this formula on both lists: =LEFT(A1,LEN(A1)-1) so that it cuts off the last number on each list. I then run a VLOOKUP to determine how many accounts in the list of 24K appear in the list of 75K. This is not working, it appears excel is not recognizing the numbers in the new columns because it has the formula in the cell as opposed to the ID number. Any ideas??

 

[SkipVought]

Hi,

Can't read your mind.

Please post a sample of both tables that contain related data.

Please post your formula.

Please post all relevant information related to clarifying these examples.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Salut39]

Hi Brendan,

Try to play with

=VALUE(LEFT(A1,LEN(A1)-1)) - Left() converts number into text.

The Lookup values should be the same format in both places.

Yuri