Please help with this formula!

[Scott82]

Good morning!

I have this formula to check if "Julie" is in a set of data. I want to check if she is in a another set of data and if she is to return "Millington"
How do I add in this part of the formula to return the original sum and this one??
Thios is the formula I have already!
=IF(ISNA(MATCH("Julie",'S:\School\SMT\Rotas\Giles House\2010 - 2011\[Giles House Term 6 2010-2011.xls]Sheet1'!$B$3:$B$13,0)),"","Giles")

Many thanks

Scott

 

[Robert Mika]

Try this:

=IF(ISNUMBER(MATCH("Julie",'S:\School\SMT\Rotas\Giles House\2010 - 2011\[Giles House Term 6 2010-2011.xls]Sheet1'!$B$3:$B$13,0)),"Giles",IF(ISNUMBER(MATCH("Julie",'S:\School\SMT\Rotas\Giles House\2010 - 2011\[Giles House Term 6 2010-2011.xls]Sheet1'!$C$3:$C$13,0)),"Millington",""))

 

[Scott82]

Thank you, I think you got it!