Need Help with a Formula.

[cchase82]

Here is to hoping someone can help me out with this.

I created a workbook that would tell me the progress of each of my students. I am in need of assistance creating a formula that will search a tab and if a student's name appears in a tab to return the information from the tab. Let me provide an example.

My sheet entitled "Scorecard" has Names in column A with A1 being the heading 'Names'. Column D is where the student's attendence would go from the sheet entitled "Attendence." I would like the formula to search the "Attendence" sheet for a student's name, and if their name appears in the "Attendence" sheet, then return only the information that is tied to that student's attendence, which is populated on the "Attendence" sheet in the D2:D79 rows.

I hope that I explained this properly and someone can help.

 

[rallcorn]

Welcome!

Assumptions for ATTENDANCE worksheet:
1) the info that you wish to capture is contained in a single column (for example let's say col H)
2) Student's name is in column A
3) Student is only listed once

On your formula in D2 on Scorecard:
=INDEX(Attendance!H:H,MATCH(Scorecard!A2,Attendance!A:A,FALSE),1)

 

[cchase82]

WOW! Thank you so much! How can I modify this formula if their name appears more than once on the attendence sheet? For example the "Attendence" sheet starts out as blank but as an incident occurs we add to the sheet. Which means a person's name can appear more than once on the "Attendence" sheet.

 

[rallcorn]

What version of Excel are you using? And, is the data you wish to return a numeric value?