IF/THEN on Bulk Orders (1-14,15-49, etc)

Ladies, Gents...

First thanks for having this forum available. Second, thanks in advance for any help you can provide.

Third...

I'm putting together a spreadsheet to use for a business plan that shows the Cost of Goods Sold for Assembly Items, and then measures the markup, etc.

I have available pricing ranges from a vendor, 1-14, 15-49, 50-199, and 200+

Currently, I input values of what completed products I need to produce, and the spreadsheet automatically fills the values of how many inventory items to order (including rounding up for things sold in packages)

Right now, I have to manually check what pricing bracket I'm in, but I'd like to have the spreadsheet do it for me.

How do I get the spreadsheet to automatically choose whatever bulk price bracket I'm in based on the value in the "Total Number Ordered" field?

Again, thanks in advance!
Daniel

Thanks for the welcome, and the help so far!

I input this, because my table is horizontal:

=HLOOKUP(L4,G3:K27,4,FALSE)

It came back with a "Value Not Available Error"

I'm assuming it's because I'm ordering 12, and the table only shows the values of 1, 15, 50, and 200. How do I get it to select the values from a range of 1-14, etc?

Yellow is the Data Table, Orange is the cell I need the formula in, and red is the number of items I'm pulling from.

I tried that and it still was puling the wrong value. I needed to change that and the Row_Index_Number, or the third value in the formula, needs to reflect the row in the Table Array, not the row in the document.

Thank you so much for the assistance. I'm sure I'll be back with some off the wall question in the future.

Your INDEX function brings back the correct number (so it works) but alerts "Formula Omits Adjacent Cells". Out of curiosity, what does that mean?

are you using 13? It's a windows product, so I don't expect it to make sense 100% of the time.