Hi,
I have a formula that I have working in other sheets but on this particular sheet it's not working & I have checked & double checked but cant find what is wrong.......The first part is working but if there is't a name in the Players_Names list it returns a #N/A instead of a Bye (I've also tried a range instead of define name). Can someone help before I go nutty!!!



=IF(AND(Comp_Data!$H$10>32,Comp_Data!$H$10<=64),IF(VLOOKUP($A7,Players_Names,2,FALSE)<>"",VLOOKUP($A7,Players_Names,2,FALSE),"Bye"),"")