Excel - COLUMN Function Problem - Expert Solution

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
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

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.