Using IF & OR

[Scott82]

Hi guys, can you take a look at the formula below and see whats wrong with it please?
=IF(OR('[Giles House Term 6 2010-2011.xls]Sheet1'!B3:B13)="Julie","Giles","")

Many thanks!

 

[jasonb75]

Maybe

=IF(OR('[Giles House Term 6 2010-2011.xls]Sheet1'!B3:B13)={"Julie","Giles"}),"")

It's much easier to see what's wrong if you tell us what you're trying to do.

 

[Matty]

Hi,

You can't use OR like that.

Could you elaborate further in terms of what you're trying to achieve? A small sample of data would also help.

Matty

 

[CharlesChuckieCharles]

=IF('[Giles House Term 6 2010-2011.xls]Sheet1'!B3:B13="Julie","Giles","")

=IF(MATCH("Julie",Sheet1!B3:B13,0),"Giles","")

this is better

=IF(ISNA(MATCH("Julie",Sheet1!B3:B13,0)),"","Giles")

 

[Scott82]

I'm trying to find out if "Julie" is any of the cells B3:B13. If she is then return "Giles"!

 

[Scott82]

You Star!!!!
=IF(ISNA(MATCH("Julie",Sheet1!B3:B13,0)),"","Giles")

Is exactly it!
How about if i also want to check say Sheet2 B3:B13???? But to return Millington??