if and function

[Patcheen]

im using this formula to give me whats in fixtures and results I4 but it says

You've entered too many arguments for this function


=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101,'Fixtures and Results'!I4,"")

do i need to add something to it if so what?

Tai

the result should be Faranfore

 

[Patcheen]

you are a super star thank you so very much it is brill thank you it works perfectly dont know how you thought of all that but id love to know thank you so very very much again for you help and time with this

 

[Yongle]

That's great - glad it gives you what you need