Maverick1501
New Member
- Joined
- Mar 8, 2010
- Messages
- 8
Ok... I am now using =vlookup to reference a particular code to a product description, and my particular cost. I now need to formulate the cost to the customer, though the different products will be sold to different customers at different prices...
Example:
If cell 'A1' = Tesco's, the cost for product 123456 will be £1
If cell 'A1' = Sainsburys, the cost for product 123456 will be £1.20
I have a table with the product codes in 1 column, and the costs to different customers in others.
Any thoughts?
Example:
If cell 'A1' = Tesco's, the cost for product 123456 will be £1
If cell 'A1' = Sainsburys, the cost for product 123456 will be £1.20
I have a table with the product codes in 1 column, and the costs to different customers in others.
Any thoughts?