IF/Vlookup returning #N/A

[How How]

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"),"")

[Jonmo1]

Try

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

[How How]

Hi Jonmo1,
Sorry for the late reply, but this did the trick.....Thank you so much!! (I'm building sports comp sheets).