vlookup

Dumb question: How can you get a value other than #N/A if what your are looking for is not found.

=if(iserror(vlookup(…),“value not found”, vlookup(…)) should do it.

got it… thanks

omg!!! thank you… :P, i’ve been trying to figure that one out too.

Dang same from me. I have been trying to figure it out too. What I have been doing is referencing the cell with and IF statement and telling it to display another (blank) cell if there is no value in the cell for the first argument of the VLookup. Anyways thanks that’s much better than what I was doing.

Or use ISNA(). IF( ISNA(Cellref), , , )

yeah pretty much the same thing, I am in the habit of always using iserror because it also catches #DIV/0! errors.

Try using SUMIF instead - it’s simpler in this case.