IF(OR(ISERROR...(ISBLANK problem

[penfold]

Hi,

This formula is returning #VALUE! - please can you help me correct/understand why?

=IF(OR(ISERROR(VLOOKUP($A2,Projects!$A$2:$K$1000,8,0)),ISBLANK(VLOOKUP($A2,Projects!$A$2:$K$1000,8,0)),""),VLOOKUP($A2,Projects!$A$2:$K$1000,8,0))

Thank you

[zbor]

I don't think you need to check if it return blank. Anyway you have closing parenthesis problem, but try:

=IF(ISERROR(VLOOKUP($A2,Projects!$A$2:$K$1000,8,0),"",VLOOKUP($A2,Projects!$A$2:$K$1000,8,0))

[penfold]

Hello,

Thank you for your response.

The formula you posted doesn't work - the warning box says too many arguements.

I do need to include both ISERROR and ISBLANK - ISERROR is preventing me from getting #N/A when the lookup_value is empty and ISBLANK is preventing me from getting 00/01/1900 when the col_index_num is empty.

Thank you

[zbor]

Here, use this:

=IF(ISERROR(1/VLOOKUP($A2,Projects!$A$2:$K$1000,8,0)),"",VLOOKUP($A2,Projects!$A$2:$K$1000,8,0))

[arthurbr]

Perhaps

Please Login or Register  to view this content.