Ho to get only one price if you have two columns with diffident prices in

[hendrikbez]

I have a xls file, with three worksheets, on the first one I have (invoice) with a invoice template.
On this I have 3 columns "sales Price" , "Unit Price and "total".

on my work sheet "Products", I can have amounts in both Unit ans Sales, so on my worksheet "Invoice" I only
want to show "Sales" if there is and not unit price, so if there is no sales, it must show unit price.

Here is my sample

[JBeaucaire]

I've added dynamic named ranges to your CLIENT and PRODUCT sheets. So as you add more clients and products, the dynamic list of names and clients will expand itself.

I added those clients as a drop down on the INVOICE sheet cell D18. Try it. Now it's much easier to select a customer by name.

I added those products as a drop down on the INVOICE sheet in cells D24:D40. Now it's much easier to select a product by name.

I've replaced the formulas to lookup the address info and the product prices with standard VLOOKUP formulas. Your column P is no longer needed.

I've updated the pricing formulas to show one price or the other, not both. I've updated the totals accordingly.

[hendrikbez]

ThankYou, it is working.