Multiple if statement forumla help based on given shipment weights.

[excelguru10]

HI All,

I am looking for some formula help in the attached spreadsheet.

Column A has a bunch of shipments weights. column C has an identifyier on what catgetory those weights fall into. Is there a way to create a formula that can quickly "tag" each of the associated weights with the correct identifyer i.e. <500, 10K-20K, 20k-30K, ect. (see below categories.)

can someone input the formula into my sheet to show me how that would work? many thanks!

categories
credit = Negative weight
N/A = "no weight listed"
<500 LBs
500 to 1000 lbs
1000 to 2500 lbs
2500 to 5000 lbs
>5000 lbs

[protonLeah]

Title updated...

[Sam Capricci]

are you sure you attached the correct sheet? Given that, I'm guessing at what you want based on your narrative and offering this which you can adjust as necessary... =LOOKUP(A2,{0,500,1000,2500,5000,5001},{"10k-20k","20k-30k","30k-40k","40k-50k","50k-60k","60k and above"})

[excelguru10]

Please see the new data I just uploaded. That should be much easier and clearer now. Sorry about that.

[Crooza]

try this in E2 and drag down.

Please Login or Register  to view this content.

[Sam Capricci]

I am attaching your sheet with two possible solutions. One involves a modification to the lookup formula I gave you earlier and the other is based on a vlookup using a reference table and true.