I have a column (f) that has a vlookup formula that looks up the employee and
brings back their overtime rate, column e shows the overtime hrs worked if
any.
column g gives a total amt by multiplying f*e. In column J2 I want a total
monthy cost the sum of G3:g500. The problem, it shows a #NA in the J2
column. In column F if I do not have any inform from the vlookup, it gives a
#NA, so In column J it also gives a #NA. Even though I have numbers in
g3:g200, I am not showing the total sum in J2, it is showing a #NA. What can
I do to get rid of the #NA error?

Thanks,

In Column F change the VLOOKUP() formulas to:

=IF(ISNA(F3),"",Your VLOOKUP() formula)

and copy down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pammy" wrote in message
...
I have a column (f) that has a vlookup formula that looks up the employee
and
brings back their overtime rate, column e shows the overtime hrs worked if
any.
column g gives a total amt by multiplying f*e. In column J2 I want a
total
monthy cost the sum of G3:g500. The problem, it shows a #NA in the J2
column. In column F if I do not have any inform from the vlookup, it
gives a
#NA, so In column J it also gives a #NA. Even though I have numbers in
g3:g200, I am not showing the total sum in J2, it is showing a #NA. What
can
I do to get rid of the #NA error?

Thanks,