Solved Vlookup 2nd Duplicate row in MS-EXCEL

November 3, 2010 at 05:29:06
Specs: Windows XP
Hi Experts,

I need to vlookup Sheet1 with values in Sheet2 in MS-EXCEL 2007. I have a column " User ID" in Sheet1 with which i am making vlookup with same UserID column in Sheet2. UserID values in Sheet2 are repetitive. There are 3 rows or 4 rows with same userID in sheet2. Now while iam making vlookup i can get only First Row of those duplicates. But i need 2nd duplicate row ( They are sorted according to the "address" column alphabetically). Please help me.

Thanks in Advance.


See More: Vlookup 2nd Duplicate row in MS-EXCEL

Report •

November 3, 2010 at 06:52:34
✔ Best Answer
VLOOKUP will only find the first occurrence of the lookup_value.

Rather than trying to explain how to find the second occurrence, I'll refer you to this site.

Once there, press Ctrl-f and enter second.

That should take you to the solution for finding the second occurrence of a value in a list.

Report •

May 23, 2011 at 06:40:01
Thank you!

Report •
Related Solutions

Ask Question