I'd guess that one of those functions was returning text--not a number.

If you put each formula in separate cells, what do you get returned from each.

japc90 wrote:

The below formula is not working. When I used the same formula to pull
the values from cells 2-5 of the accompanying spreadsheets it worked
perfectly. But for cells 6-7 I get "#VALUE!."

Any ideas?

=VLOOKUP($A$5,FIRE!$A$4:$O$30,6,FALSE)+VLOOKUP($A$ 5,AUTO!$A$4:$O
$30,6,FALSE)

Thank you in advance.

--

Dave Peterson