Excell. Problems in creating an order sheet. 2

[bojas]

I have made an order sheet that accesses my price list on product code with VLOOKUP. Trouble is that if I set up the order sheet with 25 active rows then the ones I don't use all show the default result - no data, which makes the page look very untidy. As well as that, I can't sum the costs of each item on the order sheet unless I do it manually for each order. Is there a function that will delete functions from rows not in use?
Is there a function that will sum only those cells which have values in them?
Thanks for your help.
bojas

 

[GlennUK]

Why don't you wrap your VLOOKUP in an IF function, similar to this:

=IF(prodcode="","",VLOOKUP(prodcode,prodlist,colnum,rangeflag)

Cheers, Glenn.

 

[01Patrik]

Or

=if(isna(vlookup(...))=true;"";vlookup(...)

where ... is you original function. This replaces all N/A with nil. (You can use ISERR also, replaces all error messages with nil)

// Patrik

 

[bojas]

Thank you both very much. Your advice is clear and works. Many many thanks. bojas