Good afternoon Excel Experts! I have used this template for a Vlookup and have been having troubles that I simply cannot pin down. Some duplicated numbers in Columns A and C will NOT appear in Column B. I am also trying to work it out where when the results are displayed that Excel will tell me in a pivot how many loans are on both lists and how many loans are on each specific list. Any little bit of assistance would be GREATLY appreciated.
There's only 3 cells with data, and they look as though they might be headers.
The only other cells with anything in them are in columnn B where there's a bunch of VLOOKUPs.
If posting code please use code tags, see here.
My apologies. This attachment has a list of numeric values to be compared. In the past, I've wondered if it was the formatting.... "General" vs "Text." But those proved to not be the case.
Can you give an example of where a duplicate isn't being found?
Having Text values could actually be a problem but I can only find one number as text - 2941 in row 20.
Last edited by Norie; 12-06-2012 at 04:13 PM.
Dang.... well, I could....however, for security purposes the list of numbers I am working with I cannot submit here.... So, I had to generate a list of numbers that I could plug in. I'll attempt to replicate the issue.
That's the troubling thing to begin with. The issue isn't consistent.
If there are numbers as text that is going to cause problems.
With VLOOKUP, and most lookup type formulas, you need to match like with like, eg number with number, text with text.
I'm very sorry, Norie. I cannot get the issue to repeat itself. But the original list isn't something I can post online, either. I did change the lists to 'General' since they are just numeric characters. However, on that list......the problem still persists. I'm wondering if it is the formula itself....
=VLOOKUP(A2,$C$2:$C$1397,1,FALSE)
perhaps try
=COUNTIF(A:A,c2)
and/or
=COUNTIF(C:C,A2)
copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks