how do i replace #n/a in a vlookup?

You're welcome, Steve.

Try to work out what the formula is actually doing - IF(ISNA(...) means "If
it is an error", so basically the formula says:

If it is an error then return zero (was blank), otherwise return the result
of the VLOOKUP.

Pete

"Steve" wrote in message
...
Perfect thank you

"Pete_UK" wrote:

Change the "" to a zero in the middle of the formula.

Hope this helps.

Pete

"Steve" wrote in message
...
Hello,

i've done this and now i get a blank instead of #n/a, here is mine:

=IF(ISNA(VLOOKUP(F2,BUYS!$F:$P,7,FALSE)),"",VLOOKU P(F2,BUYS!$F:$P,7,FALSE))

Any thoughts on how to get it to be a zero?

"Mike H" wrote:

Try

=IF(ISNA(VLOOKUP(L2,'March
Chargebacks'!A$1:F$613,6,FALSE)),"",VLOOKUP(L2,'Ma rch
Chargebacks'!A$1:F$613,6,FALSE))

Mike

"infinite1013" wrote:

Can you please show me how to replace the #N/A result with 0?
=VLOOKUP(L2,'March Chargebacks'!A$1:F$613,6,FALSE)