Vlookup

[Tablemountain]

What do i need to add to my vlookup formula when the result comes back a #N/A and i want it to read Zero (0)?

 

[WinteE]

if(isna(vlookup),0,vlookup)

 

[Expiry]

=IF(ISNA(yourvlookup),0,yourvlookup)

 

[Tablemountain]

=IF(isna,VLOOKUP(G20,$B$10:$D$669,3,FALSE),0) am i missing something?
now i get a #name? result

 

[excelsishya]

Hi,

Wrap iferror function around you vlookup and give zero in 2 nd argument.

Use =iferror(vlookup,0)

If you are using 2003 use if and iserror

=IF(ISERROR(VLOOKUP(D7,$G$9:$H$9,2,0)),0,VLOOKUP(D7,$G$9:$H$9,2,0))

 

[Expiry]

=IF(isna,VLOOKUP(G20,$B$10:$D$669,3,FALSE),0) am i missing something?
now i get a #name? result

=IF(isna(VLOOKUP(G20,$B$10:$D$669,3,FALSE)),0,VLOOKUP(G20,$B$10:$D$669,3,FALSE))

Notice that you're performing the vlookup twice, so if you have a lot of these it could affect performance times.

 

[T. Valko]

What do i need to add to my vlookup formula when the result comes back a #N/A and i want it to read Zero (0)?

The best solution depends on what version of Excel you're using?

When the formula is not returning #N/A what type of data does it return? Is it text? Numeric? Could be either?

 

[Tablemountain]

thanks Expire, formula worked, thank you all for your input.