vlookup output can't be summed?

[kbrownk]

Hi,

I have the following formula:

=V67/2+VLOOKUP(P24,J$2:W$6000,14,FALSE)

Here, v67 and the value returned from the vlookup will both be numbers. But I get VALUE#! returned instead of adding them together. I'm unsure why they're incompatible, but does anyone know an easy fix?

Thanks,
K

 

[Jonmo1]

Are you sure you're vlookup is returning a number?

What does this return
=ISNUMBER(VLOOKUP(P24,J$2:W$6000,14,FALSE))

 

[kbrownk]

Actually, the v67 wasn't a number (was supposed to be v24)...in copying and pasting values I was made an error in referencing cells. Thanks!