Excel Vlookup ... Problem [Closed]

Report
Posts
2
Registration date
Tuesday January 28, 2014
Status
Member
Last seen
May 5, 2014
-
Posts
3
Registration date
Thursday January 30, 2014
Status
Member
Last seen
January 30, 2014
-
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

1 reply

Posts
3
Registration date
Thursday January 30, 2014
Status
Member
Last seen
January 30, 2014

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!