VLOOKUP question
 

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

VLOOKUP question
 

Never mind...found out to include the entire thing in one IF statement...here
is what I did

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



"ssciarrino" wrote:

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

VLOOKUP question
 

=if(a17="","",if(isna(......



ssciarrino wrote:

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

--

Dave Peterson

VLOOKUP question
 

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

--
Regards,
Tom Ogilvy



"ssciarrino" wrote:

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