D
dhunter43
I have 15 columns, with different headings, in worksheet1. I have a data
input form arranged in rows in worksheet2. I used a lookup function to locate
and move data from worksheet2 to worksheet1. My problem is that the Lookup
function in the adjacent cell adopts the data in the previous cell even
though the function should return #N/A.
The other possibility that I really like is to add the lookup function as an
argument inside an IF function. This way if there were no data the formula
would return a "0". Is this possible and what would the expression look like?
input form arranged in rows in worksheet2. I used a lookup function to locate
and move data from worksheet2 to worksheet1. My problem is that the Lookup
function in the adjacent cell adopts the data in the previous cell even
though the function should return #N/A.
The other possibility that I really like is to add the lookup function as an
argument inside an IF function. This way if there were no data the formula
would return a "0". Is this possible and what would the expression look like?