You can use an IFERROR statement,
=IFERROR({your VLOOKUP statement}, 0 )
This will return 0 if the VLOOKUP returns an error.
You can use an IFERROR statement,
=IFERROR({your VLOOKUP statement}, 0 )
This will return 0 if the VLOOKUP returns an error.
Harley2
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks