| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to display price in $ or £ dependant on supplier
Hi,
I hope someone can point me in the right direction ! My workbook has a number of sheets as below. On my product list sheet I have a list of suppliers, some UK and some USA based, I have used a data validation list to allow the salesmen to select a product and display the cost =VLOOKUP(A20,partslist,2,FALSE) On the sales sheet I have two columns, A: USA list price B:UK list price I need to put the right cost in the correct column. Thanks for any help you can give. Jared. -- New excel user, please pass ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Supplier list | Excel Worksheet Functions | |||
| Subtotal by Month and supplier | Excel Worksheet Functions | |||
| Supplier scorecard | Excel Discussion (Misc queries) | |||
| How do I show the low-price supplier from seven different quotes? | Excel Worksheet Functions | |||
| How do you display negative numbers in the unit price column? | Excel Worksheet Functions | |||
Threaded Mode
