Need to check if data exist in another worksheet

**VladVerishko** · 02-22-2015, 10:25 AM

I am making a spreadsheet where there are two different worksheets , one with student information. This includes their status on a course (Enrolled/Not Enrolled) The second worksheet is the enrolment worksheet which contains student names and the course they are enrolled into. I need a formula to check if the students name is on the enrolment worksheet and if it is then change the student status on the first worksheet to "Enrolled" and if they aren't on it then keep it at "Not Enrolled" Can Anyone help me to solve this problem?

**Pepe Le Mokko** · 02-22-2015, 10:34 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Vikas_Gautam** · 02-22-2015, 11:09 AM

Assuming Column A contains the Student Names on both worksheet. The formula in Column B of Student Worksheet would be:-

Formula:

Please Login or Register  to view this content.

Drag down.

SHEET2 is the enrollment sheet.
Better if you attach a sample workbook next time as it becomes easier for us you know.

**MarvinP** · 02-22-2015, 11:14 AM

Hi Vlad and welcome to the forum,

It is a little hard to understand your two sheets layout but see if the attached fits what you are asking. I have an array formula in B2 on sheet 1 of:

=IF(ISERROR(MATCH($A2 & B$1,Sheet2!$A$1:$A$24&Sheet2!$B$1:$B$24,0)),"Not Enrolled","Enrolled")

It is an array formula and needs to be entered using Control+Shift+Enter. Read: http://www.cpearson.com/excel/ArrayFormulas.aspx