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.

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


"Hamed parhizkar" wrote:

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.

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

cheers
Carlo

On Dec 12, 1:11 pm, JMB wrote:
try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(. ..)))



"Hamed parhizkar" wrote:
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 -

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.


"carlo" wrote:

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

cheers
Carlo

On Dec 12, 1:11 pm, JMB wrote:
try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(. ..)))



"Hamed parhizkar" wrote:
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 -

Hey JMB,

you're right, thanks for the correction

Carlo

On Dec 13, 9:21 am, JMB wrote:
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.



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

cheers
Carlo

On Dec 12, 1:11 pm, JMB wrote:
try setting it up like this:
=IF($K$35="","",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(. ..)))

"Hamed parhizkar" wrote:
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 -