vlookup

  • Thread starter Thread starter Cory
  • Start date Start date
C

Cory

Does anyone know of a way to avoid the #VALUE
error with a vlookup if the data isn't present
in the table array? I would like it to return
a value of 0 (zero) if the data isn't present.

Thanks for any help
 
I think that if the VLOOKUP formula is returning the #VALUE error
message (rather than the #N/A error message) it will continue to do so
with the formula you suggested.

Alan Beban
 
Does anyone know of a way to avoid the #VALUE
error with a vlookup if the data isn't present
in the table array? I would like it to return
a value of 0 (zero) if the data isn't present.
Click to expand...

Show your *EXACT* formula. It's common for VLOOKUP to return #N/A, but *VERY*
unusual for it to return #VALUE! unless the cell referenced in the table
evaluates to #VALUE! or VLOOKUP's 3rd or 4th arguments are invalid.
 
Back
Top