It sounds like the data you're returning is really text.

I think I'd try changing the base data to real numbers.

If you want to try, one quick way is to
copy an empty cell
select your range to convert
edit|paste special|check Add

Now '123 will be 123 (text vs numbers).

And your formula that adds should work ok.

Nigel Letford wrote:

I am using a lookup formula thats retrieves information from a list on a
different sheet. The RESULT i am getting is working. But when I try to use a
simple adding formula in another cell to add my RESULTS together I get an
error (VALUE!)
Can anyone help?

--

Dave Peterson