brendan187
Technical User
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??