Excel Query Urgent Please.

Solved/Closed
wasey - Jan 13, 2015 at 10:31 AM
wasey Posts 3 Registration date Tuesday January 13, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 02:12 AM
Hello,

I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names will change daily.

Sheet 1
A B C D E F
1 Activity Name
2 12364 Saneel
3 6543 Karthik
4 7841 Somen
5 9654 Deepak
6 2541 Saneel
7 65489 Hema
8 4567 Sachin
9 9135 Karthik


I have a standard format in sheet 2 where i need the result as below -

Sheet 2

1 A B C D E F
2 Saneel 12364 2541
3 Karthik 6543 9135
4 Somen 7841
5 Deepak 9654
6 Hema 65489
7 Sachin 4567
8

I will have fixed the names in cell, I need the column B and C to populate from sheet 1 based on who has done the activity.

Please let me know this urgently.

1 reply

tlynnec Posts 10 Registration date Wednesday December 24, 2014 Status Member Last seen January 13, 2015
Jan 13, 2015 at 01:32 PM
vlookup would be my choice here. the catch is, in order for it to work, you need the names on sheet 1 to come before the numbers. is it possible to switch the orders of the columns on sheet 1 so that the names come first?
0
tlynnec Posts 10 Registration date Wednesday December 24, 2014 Status Member Last seen January 13, 2015
Jan 13, 2015 at 01:33 PM
0
How would a VLOOKUP work here?
My understanding in Sheet2 is empty so there is nothing to compare against.
Plus, the result has TWO columns of numbers.
0
tlynnec Posts 10 Registration date Wednesday December 24, 2014 Status Member Last seen January 13, 2015 > RayH
Jan 13, 2015 at 02:13 PM
the post says "I will have fixed the names in the cell" for sheet 2, so the names can be used as the lookup value. the vlookup would then insert the numbers from sheet 1 according to the name matches. The point here (as I understood it) was to take the randomly ordered list from Sheet 1 and sort the activity numbers to a fixed list of names on sheet 2.
0
Sorry, you are correct about the name list in sheet 2. Missed that somehow.

However, the 2nd point still stands.
Per the example:

Saneel 12364 2541

Saneel has two numbers against the name.
0
tlynnec Posts 10 Registration date Wednesday December 24, 2014 Status Member Last seen January 13, 2015
Jan 13, 2015 at 02:51 PM
I missed the double results. however, vlookup will still do the job, it's just a little more complicated (https://www.excelanytime.com/excel/index.php?option=com_content&view=article&id=119:vlookup-multiple-values-return-multiple-corresponding-values-for-one-lookup-value&catid=77&Itemid=473 )

Pivot tables are also an option here. I just generally go to vlookups before I mess with pivots. :)
0