Hello. I am trying to compute a total part cost based on various anticipated quantities over five years and the appropriate price
quantity breaks. My research shows there are a lot of posts using Vlookup, but my data is across the row & not down a column.
I have three tables. The first is the parts table with various data & including the part quantity price breaks and the associated
price for each break. The next table is the estimated quantity for each part by year. The final table that I a trying to find an
appropriate formula for is the cost of the parts for each year based on the quantity breaks, the associated price for that particular
break and the anticipated quantities for each year.
I have attached an example spreadsheet & would greatly appreciate anyone's help. Hopefully, this can be accomplished using
an Excel formula vs. VBA.
Thank you.
Bookmarks