Previous Topic Next Topic

Excel Query Urgent Please.

Solved/Closed
Report
-
Posts
3
Registration date
Tuesday January 13, 2015
Status
Member
Last seen
January 15, 2015
 -
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

Answer 1 / 1
Posts
10
Registration date
Wednesday December 24, 2014
Status
Member
Last seen
January 13, 2015
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
Report
Posts
10
Registration date
Wednesday December 24, 2014
Status
Member
Last seen
January 13, 2015
more info on the vlookup function: https://www.howtogeek.com/howto/13780/using-vlookup-in-excel/
0
Report

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
Report
Posts
10
Registration date
Wednesday December 24, 2014
Status
Member
Last seen
January 13, 2015
 > RayH
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
Report

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
Report
Posts
10
Registration date
Wednesday December 24, 2014
Status
Member
Last seen
January 13, 2015
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
View all 10 comments
Ask a question