I have this formula

=IF(ISNA(VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) =TRUE,
"DONOR NOT VALID",VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE))

on cell B17.

When the user selects a value in A17 from the drop down, it goes to sheet
'Data-FSList' to retrieve a value. If the value is not there it comes back
in field B17 'DONOR NOT VALID'

However when A17 contains no value from the drop down and is blank I do not
want 'DONOR NOT VALID' to show in cell B17.

Is there a way to add to the formula above if A17 is blank then B17 is blank

thanks

=IF(A17="","",IF(ISNA(VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)),
"DONOR NOT VALID",VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)))

Note that you don't need the "=TRUE"

Regards

Trevor


"ssciarrino" <(E-Mail Removed)> wrote in message
news:959B29FD-5504-400B-AC23-(E-Mail Removed)...
>I have this formula
>
> =IF(ISNA(VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) =TRUE,
> "DONOR NOT VALID",VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE))
>
> on cell B17.
>
> When the user selects a value in A17 from the drop down, it goes to sheet
> 'Data-FSList' to retrieve a value. If the value is not there it comes
> back
> in field B17 'DONOR NOT VALID'
>
> However when A17 contains no value from the drop down and is blank I do
> not
> want 'DONOR NOT VALID' to show in cell B17.
>
> Is there a way to add to the formula above if A17 is blank then B17 is
> blank
>
> thanks