Looking up data in a different worksheet based on criteria

**ConneXionLost** · 10-14-2010, 02:29 PM

You could most likely do everything you need to with the VLOOKUP function. If you post a sample workbook, showing you would be easier.

**GaidenFocus** · 10-14-2010, 02:57 PM

so what i get from your post you want to type in the part and it automatically puts in the fees?

thats simple

in the column that you want to have the fees show up in just type the following

(lets say your part is in a1)

=IF(A1=0,0,VLOOKUP(A1,costs!$A$1:$B,2,false))

using this it will be a zero if you have not yet entered the part, and when you do, if it fins a match then it will give you the cost for the part number. adjust the cell references as neccisary, as im not sure where exactly you have your lists.

**jeeperv6** · 10-15-2010, 12:11 AM

Originally Posted by ConneXionLost

You could most likely do everything you need to with the VLOOKUP function. If you post a sample workbook, showing you would be easier.

Here's most of the spreadsheet I have set up.

Brokerage contains all the brokerage fees I have to add to my costs.

Our Costs is the sheet that includes all my combined costs.

What I want to do is have Excel look up the value of an item, ie the Oil Cooler & put in the correct brokerage fee (93.50) into the the cell under the Broker(age) Fees column.

I don't mind looking up the correct brokerage fees on a small sheet (this is a small one for me), but on the larger sheets with 100 or more items it's a little bit tedious.

I've attached the sheet.

**ConneXionLost** · 10-15-2010, 02:52 AM

Mods made to "Our Costs" tab, as well as mods (in yellow) to the "Brokerage" tab.

Hope that helps.

Cheers,

**jeeperv6** · 10-15-2010, 08:42 AM

Originally Posted by ConneXionLost

Mods made to "Our Costs" tab, as well as mods (in yellow) to the "Brokerage" tab.

Hope that helps.

Cheers,

Thank you, it helps alot. The one thing I didn't mention though and from what I've read is that Excel tends to go with the closest lower match if it doesn't find an exact match.

Can I get Excel to use the next highest level.

For example, instead of using 93.50, have it use 102.50?

Thank you again for getting me on the right track.