VLOOKUP with multiple results

Hello!

I have two sheets and I'm trying to find a way to bring to a order tracking sheet (2nd image) different information about shipping cost (1st image) but my vlookup brings juts the first result. can anyone help me understanding if there is another function?

Shipment data sheet:

Order tracking sheet:


Thank you in advance for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!