VLOOKUP ERROR HOW DO YOU MAKE IT BLANK

[Hamed parhizkar]

In this following formula, when the reference cells are not inputed yet an
N/A shows in the cell. The formula is as follows
=IF($K$35="","",VLOOKUP($K$35,'C:\Documents and Settings\dglenn\Desktop\[A-2
DAILY.xls]DATA BANK'!$A$1:$AH$100,2,FALSE))

How can this cell be a blank instead of N/A when there is nothing in the
referencing cells.

 

[JMB]

try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)))

 

[carlo]

Or without 2 ifs, but an and:
=IF(and($K$35="",ISNA(VLOOKUP(...)),"",VLOOKUP(...)))

cheers
Carlo

try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)))

In this following formula, when the reference cells are not inputed yet an
N/A shows in the cell. The formula is as follows
=IF($K$35="","",VLOOKUP($K$35,'C:\Documents and Settings\dglenn\Desktop\[A-2
DAILY.xls]DATA BANK'!$A$1:$AH$100,2,FALSE))

How can this cell be a blank instead of N/A when there is nothing in the
referencing cells.- Hide quoted text -

- Show quoted text -

 

[JMB]

If K35 is not blank, but some value that does not exist in the table this
will throw an error. I assume you meant to use OR. Although if a blank does
not exist in the OP's lookup table, the test K35="" may not be needed at all.

Or without 2 ifs, but an and:
=IF(and($K$35="",ISNA(VLOOKUP(...)),"",VLOOKUP(...)))

cheers
Carlo

try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)))

In this following formula, when the reference cells are not inputed yet an
N/A shows in the cell. The formula is as follows
=IF($K$35="","",VLOOKUP($K$35,'C:\Documents and Settings\dglenn\Desktop\[A-2
DAILY.xls]DATA BANK'!$A$1:$AH$100,2,FALSE))

How can this cell be a blank instead of N/A when there is nothing in the
referencing cells.- Hide quoted text -

- Show quoted text -

 

[carlo]

Hey JMB,

you're right, thanks for the correction

Carlo

If K35 is not blank, but some value that does not exist in the table this
will throw an error. I assume you meant to use OR. Although if a blank does
not exist in the OP's lookup table, the test K35="" may not be needed at all.

Or without 2 ifs, but an and:
=IF(and($K$35="",ISNA(VLOOKUP(...)),"",VLOOKUP(...)))

cheers
Carlo

try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)))
:
In this following formula, when the reference cells are not inputed yet an
N/A shows in the cell. The formula is as follows
=IF($K$35="","",VLOOKUP($K$35,'C:\Documents and Settings\dglenn\Desktop\[A-2
DAILY.xls]DATA BANK'!$A$1:$AH$100,2,FALSE))
How can this cell be a blank instead of N/A when there is nothing in the
referencing cells.- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -