Formula for determining correct fee application.....

[SkzDaLimit]

I have a sales spreadsheet I am making for eBay Store and I am trying to come up with a formula to determine the correct fee amount. In the spreadsheet I have a drop-down in the first column that tells the type of listing. The 2nd column is amount of shipping charged, the 3rd is the fee eBay levies.

Excel Workbook
	A	L	M
18	Listing Type	Shipping Cost	Shipping Fee
19
20		$ 10.00
Sep-11

Excel Workbook
	W	X
1	All Other Items	11%
2	Books & Media	13%
3	Car Electronics	7%
4	Car Parts	10%
5	Clothing	10%
6	Consumer Electronics	7%
7	Regular eBay Auction	9%
Excel 2003 (A20 is the drop-down) This is the fee schedule based on the type of auction. Sep-11

Excel 2003

[/B]For example, if in A20 I chose "Car Parts" out of the drop down, M20 should populate the field with the correct fee ($1.00) based on the fee schedule above and the shipping cost as populated manually in L20.

Hope someone can help with this. Thanks!

 

[VoG]

Try in M20

=L20*VLOOKUP(A20,W1:X7,2,FALSE)

 

[SkzDaLimit]

Try in M20

=L20*VLOOKUP(A20,W1:X7,2,FALSE)

Worked perfectly. Many thanks!