Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet:

Beans       B-kg        Chips       C-kg
1.4oz/12    0.47544     6.5oz/20    3.679
1.48oz/12   0.502608    7oz/12      2.3772
1.86oz/12   0.631656    8oz/20      4.528

and a second sheet:

Category Name       Case Kg
Beans   1.4oz/12    ?
Beans   1.48oz/12   ?
Chips   6.5oz/20    ?

I am trying to match the type of product with the correct weight. So I need a formula that will choose the correct column based on the Category and then choose the correct row based on the name and output the result next to it.

share|improve this question
up vote 1 down vote accepted

Since you didn't provide range labels, here is a generic formula

=INDEX([Range of your First Set of Data], Match([Range of the Name you are checking],0),4)

Range of yoour first set of data should be the first table you listed. Range of the Name you are checking would be the cell adjacent to the field you are putting your value in.

I am using 4 as the last parameter because it matches the table you listed (4th column).

share|improve this answer
Thanks for your help. – user77325 Oct 18 '12 at 18:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .