# Solved Excel Question

Discussion in 'Business Applications' started by misterjw, Oct 11, 2017.

Not open for further replies.

Joined:
Apr 6, 2010
Messages:
25
Hello,

I have a list of students on one tab, with multiple columns. I have a second tab with more information about each student.

I need a formula to find the students name from tab one and look for that student on tab two then return a yes/no.

For example, on tab one I have the student Elvis Presley. I want the formula to look on tab two and tell me if Elvis has Occupational Therapy, Physical Therapy, or Transportation, and then fill in that information back on tab one.

See the example excel.

Thanks!

File size:
17.1 KB
Views:
5
2. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,423
First Name:
Wayne
looking at the spreadsheet , i think i can see what you are after and so we can use a lookup with 2 values combined with an IF to return the Yes or No

=INDEX('Tab 2'!\$A:\$A,MATCH(\$A2&C\$1,INDEX('Tab 2'!\$A:\$A&'Tab 2'!\$B:\$B,0),0)))
If there is an Error , then that match does not exist - so that would be a No
if the lookup returns the name - then its a match and Yes

=IF(ISERROR(INDEX('Tab 2'!\$A:\$A,MATCH(\$A2&C\$1,INDEX('Tab 2'!\$A:\$A&'Tab 2'!\$B:\$B,0),0))),"No","Yes")

#### Attached Files:

• ###### Sample Excel etaf.xlsx
File size:
12.2 KB
Views:
2

Joined:
Apr 6, 2010
Messages:
25
Wow, that is amazing! I never in a million years figure out that formula. Thanks so much!

4. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,423
First Name:
Wayne
you are welcome

As Seen On