IF ERROR and ISBLANK Conundrum

[Jbess]

*Hi all,

I am trying to do some data validation against some of the fields in an input form.

Basically I want to be able to do an IF error for a Vlookup to validate the currency, so if that fails it should say "INVALID", but I also would like a, if the field is blank, "PLEASE ADD ENTRY".

This is what I have so far!....

=IFERROR(VLOOKUP(Currency,Parameters!B:C,2,0),"Invalid")

I have a 3 field sheet with:

Currency (Title) - Input Field (Currency Code would be added) - Validation field (Where the IFERROR is currently located)

Thank you.

 

[mole999]

try this
=IF(A1="","PLEASE ADD ENTRY",IFERROR(VLOOKUP(Currency,Parameters!B:C,2,0),"Invalid"))

 

[Jbess]

Perfect! So Simple its ridiculous!

Thanks again!