Nested if statements with vlookups

[txbullets]

I am trying to write a function where if vlookup returns 0 or is NA then the cell is "blank" otherwise it ruturns the value of the vlookup. The function is working in that if it is 0 it is returning blank but if it is NA it si giving me a #NA. How come the second half this function is not working properly.

=IF(VLOOKUP($B12,Data!$A$7:$G$264,7,FALSE)=0,"",IF(ISNA(VLOOKUP($B12,Data!$A$7:$G$264,7,FALSE)),"",VLOOKUP(B12,Data!$A$7:$G$264,7,FALSE)))

Thank you in advance for any help you can give. If you know a better way I am open to other ways to write this.

[abousetta]

Maybe try this rearrangement:

Please Login or Register  to view this content.

abousetta

[txbullets]

Thank you I tried to flip them like that but it didn't work before. I copied and pasted yours and it worked perfect. I must have been missing some parenthesis somewhere.

[abousetta]

If you have Excel 2007 or 2010 you can also use IFERROR like this also:

Please Login or Register  to view this content.

abousetta

[abousetta]

Yes, just one missing comma or parentheses anywhere and Excel throws a fit

If you are satisfied with the responses then please mark the thread as solved.

Good luck.

abousetta