Excel Vlookup ... Problem

Closed
vinay4125 Posts 1 Registration date Tuesday January 28, 2014 Status Member Last seen May 5, 2014 - Jan 28, 2014 at 10:19 AM
Eravon Posts 3 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014 - Jan 30, 2014 at 06:18 AM
Hi,i have 3 columns(Ticket Number, Site ID and Date), i need to copy Site ID and Time according to the Ticket Number from 1st Excel sheet to 2nd excel sheet

For Example : I Have Ticket Number 425665 with Three Site ID's UW_GJ_2904 , UW_GJ_1995 , UW_GJ_0960 , So i need to copy all three site id's from 1st Excel sheet to 2nd excel sheet .... But as per vlookup only first site ID is Reflecting UW_GJ_2904 is Reflecting in all three places, which it should not(in some cases for single ticket Ex: 425771 : only one site UW_GJ_0514 will be there, it was reflecting properly, The problem is for each ticket which has more than one site ID is not reflecting properly)

First Excel Sheet :
Ticket Site id Down time
425665 UW_GJ_2904 1/21/14 4:51 PM
425665 UW_GJ_1995 1/21/14 4:51 PM
425665 UW_GJ_0960 1/21/14 4:51 PM

Second Excel Sheet:
ticket site id down time
425665 UW_GJ_2904 1/21/14 4:51 PM
425665 UW_GJ_2904 1/21/14 4:51 PM
425665 UW_GJ_2904 1/21/14 4:51 PM

if it is only one id its Reflecting properly
First excel sheet:

425771 UW_GJ_0514 1/21/14 7:44 PM

Second Excel Sheet:

425771 UW_GJ_0514 1/21/14 7:44 PM
Related:

1 response

Eravon Posts 3 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014
Jan 30, 2014 at 06:18 AM
Hi As per Logic.

For Vlookup, lookup value should be unique. If in case if you have duplicates, that will taken as first value.

For this you have to use Pivot table.
0