Ebay: Assigning values to drop down items

[sk81681]

Here is an ebay fee calculator Im working on. I cant seem to find an easy way to calculate the shipping cost column and the ebay fee column.

Shipping Cost-
=IF(G6="FRE", Shipping!J5, IF(G6="FRS", Shipping!J6, IF(G6="FR1", Shipping!J7, IF(G6="FR2", Shipping!J8, IF(G6="FRL", Shipping!J9,0)))))
This works but I have to manually change the cell names in each row. with about 100 rows, this will take forever.

Ebay Fees-
=IF(G7="FRE", Shipping!J5, IF(G7="FRS", Shipping!J6, IF(G7="FR1", Shipping!J7, IF(G7="FR2", Shipping!J8, IF(G7="FRL", Shipping!J9,0)))))

Paypal
=IF(S6=<3000, (S6*'eBay Fees'!H11)+'eBay Fees'!G11, S6*('eBay Fees'!H11+'eBay Fees'!K11)+'eBay Fees'!G11)

Pretty much the same problem but i want to incorporate the if statements that will show the correct fee for listings over $50 and $1000

Ebay does not charge a fee on shipping so that is separate. These are the only columns i need help with. Thanks

[martindwilson]

shipping cost in I6
=IF(ISNA(VLOOKUP(G6,Shipping!C:H,6,FALSE)),"",VLOOKUP(G6,Shipping!C:H,6,FALSE))

[sk81681]

That explains the shipping column but i dont understand what im seeing in this formula so i dont quite no how to take that and make it work for the ebay fee and paypal fee column. any help?