Need empty cells to return N/A

[faolan]

I'm using the following formula:

=VLOOKUP($H2,Data!$A$2:$H$400,7,FALSE)

The issue is that there are some cells that are empty or blank, and it is returning 0.00. I need it to return N/A.

Potential issue is that there may be a valid return that should be 0.00

Thanks in advance.

 

[T. Valko]

I'm using the following formula:

=VLOOKUP($H2,Data!$A$2:$H$400,7,FALSE)

The issue is that there are some cells that are empty or blank, and it is returning 0.00. I need it to return N/A.

Potential issue is that there may be a valid return that should be 0.00

Thanks in advance.

Try this...

=IF(VLOOKUP($H2,Data!$A$2:$H$400,7,0)="","N/A",VLOOKUP($H2,Data!$A$2:$H$400,7,0))

 

[faolan]

Try this...

=IF(VLOOKUP($H2,Data!$A$2:$H$400,7,0)="","N/A",VLOOKUP($H2,Data!$A$2:$H$400,7,0))

Perfect. Thought I had tried that, but I must have mis-keyed something.

Thanks very much.

 

[T. Valko]

Perfect. Thought I had tried that, but I must have mis-keyed something.

Thanks very much.

You're welcome. Thanks for the feedback!