Multiple nested IF VLOOKUPs

[Lameimpala]

Hi all,

I use these forums frequently but have never signed up!

So I'm hoping someone can help, I have a feeling it's simple but I just cant't crack it. I want to nest multiple IF/VLOOKUPs together, I think I've started correctly

=IF(VLOOKUP(A2,'.com'!A:B,2,FALSE)="NO IP",VLOOKUP(A2,'.co.uk'!A:B,2,FALSE),VLOOKUP(A2,'.com'!A:B,2,FALSE)) But I want to continue this effect for multiple sheets (there are 6 I wish to check),

i.e if the VLOOKUP doesn't find an IP address in one sheet (well, anything that isn't "NO IP") it checks the next sheet and keeps checking until the end of the workbook, sometimes NO IP may be the final result but I need to check every sheet. I just can't seem to get the syntax right. I've attached the workbook which I hope is clear.

Thanks