Pull Price from Products Sheet

Options

Hello!

I have a products sheet with all of our prices on it. The prices change from time to time so I want the separate order sheets to change automatically when a price changes. So if a customer puts an order in on their sheet, if the product matches a product on the products sheet, I want it to pull the price per item to that row. I've tried a vlookup and can't quite get it to work.

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @dwuis21

    An Index/Match will work on your Order sheet. This formula would go into your price column.

    =INDEX({Product sheet Price column}, MATCH(Product@row, {Product sheet Product column},0))

    Because this is a cross sheet reference, you will need to create these references yourself. You cannot just copy paste this formula into a sheet. Note that unlike a vLookup which uses an entire table, these ranges are individual columns. Also, make sure to edit the formula above with your actual column name for Product.

    Will this work for you

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!