O

#### ojos_delangel

First I would like to thank those who helped "Brian" with his N/A value

error by creating the blank cell. that finally helped me out with 1 out

of 2 problems (that one I'd say being the most difficult!)

Now, the problem that I am having is that by using the blank cell, it

is creating a "value" error in a cell across from it as that cell is

part of a Sum in another cell to get a total cost, so with it creating

the blank cell it is causing a invalid value for the sum cell

this is my formula

=IF(ISNA(VLOOKUP(A38,$A$134:$B$139,2,FALSE)*$I$10),"",VLOOKUP(A38,$A$134:$B$139,2,FALSE)*$I$10)

there is another drop down adjacent to this and then finally there is a

sum cell at the end, so what I would like is if there is a blank field

chosen in either drop down then it produces a 0 value and if both are

blank then it itself produces a blank field.

Gosh, I hope someone understood this, frankly, I think I just may have

confused myself.

I am supposed to have this form finished by tomorrow (Friday), so

Please if anyone can help!!

thank you again!

Take care,

Nat