Hi,
New here, first post. I've been scratching my head over this one. I usually only use basic spreadsheet functions in Excel 2003, but due to business reasons I'm having to get a little bit more complicated.
Here's my scenario. I'm beginning to get into the import business of parts here in Canada. I've got a spreadsheet that adds my costs (exchange rate, shipping, etc) to the particular item. All the parts that I am importing have different values and as such are charged different brokerage fees.
ie:
Value Brokerage
100.00 25.00
250.00 30.50
500.00 55.00
I have all my brokerage fees in a worksheet called "Brokerage". My costs are in another worksheet named "Costs". What I would like to do is have Excel look up the value of the part and automatically enter in the brokerage fee in the "Costs" worksheet.
Something like:
Item Value Brokerage
Oil Cooler 499.00 55.00
If I could get Excel to do this for me, it would save me a great amount of time spent manually entering in the brokerage fees.
Thanks for any help or suggestions on how to go about this.
Bookmarks