I created a formula...=VLOOKUP(A10,Items!A2:C5,3,FALSE) to pull Price from
the Items sheet based on a row, in this case A10, (sorry about the
redundancy)! If I clear column A, I get #N/A. I have tried to nest this
formula in an If statement but cannot seem to get it to work. If A column is
blank I want the price to be blank also. Thanks in advance!