Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that when I type a name in cell C3, it fetched the data from another sheet and returns them next to the name. example, data sheets contains: Column A- Name with all the names from A1-A10, Column B- Surname, Column C- Class room number(4.1 or 7.2) and Colums D -K- Headings are the activities. In the sheet I just type Yes or No. So on the results sheet I want to type the name, then it returns all the headings from D-K that contains a yes or no next to the name respectively.
Solved by S. L. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
01/02/2018 - 02:04
hi
User
01/02/2018 - 02:04
hi
Excelchat Expert
01/02/2018 - 02:04
where is your excel sheet?
User
01/02/2018 - 02:05
I don't have one typed up now, but tried to do it to see if is worthwhile
User
01/02/2018 - 02:05
can I type on this one?
Excelchat Expert
01/02/2018 - 02:06
yes sure
Excelchat Expert
01/02/2018 - 02:09
is that all
User
01/02/2018 - 02:10
there is more, but all info yes.
User
01/02/2018 - 02:10
so I want something that if I type a name or can get a dropdown of all the names to select, then is shows me all teh activities for that name that contains yes
User
01/02/2018 - 02:11
if I type the class, same thing etc
Excelchat Expert
01/02/2018 - 02:11
name + surname ??
Excelchat Expert
01/02/2018 - 02:11
only name ?
User
01/02/2018 - 02:11
name plus surname will be safer
Excelchat Expert
01/02/2018 - 02:13
for wayne katompa you want to highlight yes for all acitivity
Excelchat Expert
01/02/2018 - 02:13
?
Excelchat Expert
01/02/2018 - 02:13
working
Excelchat Expert
01/02/2018 - 02:13
wait
User
01/02/2018 - 02:14
so, I want to see all activity wayne is participating
User
01/02/2018 - 02:14
and his class number
User
01/02/2018 - 02:27
you still there?
Excelchat Expert
01/02/2018 - 02:28
working
Excelchat Expert
01/02/2018 - 02:29
alomost there
Excelchat Expert
01/02/2018 - 03:00
=IF(AND(B14=A2,B15=C2),VLOOKUP(D1,D1:K2,1,0)," ")
Excelchat Expert
01/02/2018 - 03:00
[Uploaded an Excel file]
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.