Hello Everyone,
I hope all is well.
I am looking for some help with the Index formula. I know that you cannot do a vlookup using multiple criteria, thus the need for an index formula. However, I am 100% new to the index formula, and it honestly confuses me at the moment. Looking to see if someone can help by providing me the formula i need to complete a workbook I am involved in. I am hoping that once I can see the formula in action, used the way i need it to, I can better understand it. With that said, here is what I need help with.
Sheet 1
I have a table on Sheet 1, with the following Data:
<tbody>
</tbody>
On Sheet 2, I have essentially the Same Table, but what I am looking to do is make it auomated so that when I type in the Description and Company name, the rest of the information autmatically populates. The idea is that, Sheet 1 has a plethora of possible options, and Sheet 2 is a consolidated list of preferred options. So, if I decide to switch from Product 1 to Product 2, I can have all the relevant and respective data auto update so I don't have to manually do that.
Sheet 2
<tbody>
</tbody>
Any and all help would be greatly greatly appreciated. Thanks in advance for your help!
Brad
I hope all is well.
I am looking for some help with the Index formula. I know that you cannot do a vlookup using multiple criteria, thus the need for an index formula. However, I am 100% new to the index formula, and it honestly confuses me at the moment. Looking to see if someone can help by providing me the formula i need to complete a workbook I am involved in. I am hoping that once I can see the formula in action, used the way i need it to, I can better understand it. With that said, here is what I need help with.
Sheet 1
I have a table on Sheet 1, with the following Data:
Description | Company | Quantity | Unit | Eq Grams | Price | Shipping | Total | Unit cost |
Product 1 | ABC Store | 8 | Ounce | 226.80 | 70.72 | - | 70.72 | 0.31 |
Product 2 | XYZ Store | 1 | Gallon | 3,628.74 | 500.00 | - | 500.00 | 0.14 |
<tbody>
</tbody>
On Sheet 2, I have essentially the Same Table, but what I am looking to do is make it auomated so that when I type in the Description and Company name, the rest of the information autmatically populates. The idea is that, Sheet 1 has a plethora of possible options, and Sheet 2 is a consolidated list of preferred options. So, if I decide to switch from Product 1 to Product 2, I can have all the relevant and respective data auto update so I don't have to manually do that.
Sheet 2
Description | Company | Quantity | Unit | Eq Grams | Price | Shipping | Total | Unit cost |
Product 1 | ABC Store | Formula | Formula | Formula | Formula | Formula | Formula | Formula |
<tbody>
</tbody>
Any and all help would be greatly greatly appreciated. Thanks in advance for your help!
Brad