Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel vlookup

Status
Not open for further replies.

brendan187

Technical User
May 6, 2014
1
US
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??
 
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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top