Thread
:
how do i replace #n/a in a vlookup?
View Single Post
#
17
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 1
how do i replace #n/a in a vlookup?
Am Dienstag, 8. Juli 2008 20:28:21 UTC+2 schrieb infinite1013:
Can you please show me how to replace the #N/A result with 0?
=VLOOKUP(L2,'March Chargebacks'!A$1:F$613,6,FALSE)
=IFERROR(VLOOKUP(...), 0)
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]