Need help on homework. INDEX, V/HLOOKUP, INDEX-MATCH

your first three, purchased state, product state and product weight can all be accomplished by using a vlookup. Some on this forum will do the work for you but you won't learn much that way. So I would suggest you begin to write the vlookup formula and see how it works.
Hint: =vlookup(the cell you are using as a reference, the range of cells that contain BOTH the value you are looking for and the value you want returned, the number of the columns over where you will find the answer you want and true or false (true if you are using approximations and your data is in ascending order, false if you are looking for an exact match))
Hope that helps. As for the pricing, looks like too much reading and I'm going to bed.
I hope that gave you a decent start.

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

My apologies, that was a canned reply - your heading pretty clearly states that this is a homework assignment, so you can ignore the title change request

What have you tried so far?

Is that the file you were given, or have you already done some work on it?

If you were to do this manually, how would you do it, and what steps would you take?

(1st thing to establish, is what needs to be done. Once you have that, you can then decide on which functions/formulas would possibly do what you need. If you don't know what you need to do, all the formulas in the world wont help )

Originally Posted by Cottonsoft

Alright, so I figured out question 1 (I think) by using =INDEX(($BC$2:$BI$8,$A$1:$AZ$52),$C$1:$AZ$1,$A$3:$A$52,1)

What is that giving you, and what are you trying to do with it?

INDEX has 3 parts...
=INDEX(range-to-search, row-to-search-in, column-to-search-in)