VLOOKUP formula - invalid

[Luis Ferreira]

I am trying to create a formula that searches for an account and if it cannot be found to enter a zero. My formula keeps giving me an error.

=-VLOOKUP("4050-1040",TrialBalance,5,0)

 

[VoG]

Try

=IF(ISNA(VLOOKUP("4050-1040",TrialBalance,5,FALSE)),0,VLOOKUP("4050-1040",TrialBalance,5,FALSE))

 

[pgc01]

Hi Luis
Welcome to the board

Remark: you should always post your excel version.

If you have excel 2007 or later, try:

=IFERROR(-VLOOKUP("4050-1040",TrialBalance,5,0),0)