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.