Need help on an excel formula? - serial side track
Hello,
I am monitoring the stocks of material non-profit into an Excel spreadsheet.
I need a formula that does the following:
The attached table showing the cost of buying a stock and retail, on the other side, both with serial # 's for the equipment. I need a formula that you sell when a device with a sale price, the costs are to be found, minus the cost of retail, so you can get benefits for my room.
Is it possible in Excel, I'm sure it's because / w Excel no limits to what you can do: o)
--- Sally
Monday, December 7, 2009
Serial Side Track Need Help On An Excel Formula?
1 comment:
If
Column A has the serial numbers for the cost
Column B is the cost of your purchase price
Column C contains the serial numbers of retail sales
Column D is the price for retail sale
D2 = - Index (B: B, Match (C2, A: A, 0))
This is the smallest number of C2 and look in the column A. There is the cost of the item in column B the cost is deducted from the retail price to D2.
You can use VLOOKUP to do the same.
= D2 - VLOOKUP (C2, A1: B100, 2,0)
Post a Comment