Looking up data in a different worksheet based on criteria

[jeeperv6]

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.