Validation - ISERROR or ISNA

[Chunky_22]

Hi

My worksheet requires users to enter a 6 digit number into cell E14. Cell G15 has a simple VLOOKUP to return a text value for the corresponding number - =VLOOKUP(F15,Data!A:B,2,FALSE)

I would like to use Validation to display a pop up error message if the VLOOKUP returns a nil result - i.e. #N/A

Any ideas?

Thanks in advance

 

[shg]

E14 isn't used in the formula

 

[Chunky_22]

Sorry! Typo.

It's meant to be E15. And the formula is =VLOOKUP(E15,Data!A:B,2,FALSE)

 

[shg]

Just the #N/A from the formula isn't sufficient?

Data validation, custom, formula: =ISNUMBER(MATCH(E15, A:A, 0))

 

[Chunky_22]

That's perfect. Thanks very much