Hello,
After many hours of surfing the web to no avail I decided to call for help here. I am good with excel but when it comes to specific functions and correct syntax I have problems.
I am trying to to have my destination cell show me the price for a specific item based on 3 criteria. 1st one is in the column of the kind of item. 2nd criteria is what type of material it is. and 3rd is what length the item is.
My "material type" is in one row with 4 different material types. My lengths for the item are in the subsequent row below. So for every "material type" there are 3 different lengths. So simply 3 columns for sizes inside the material type column. And ofcourse the item list itself in the left most column. I cannot get my formula to work to recognize all three criteria to populate the destination ccell with the relative price. I understand how to do index array with 2 match properties, but with 3 (2 rows for criteria) is not working. I have attached the sheet were my data is. On a different sheet I have 3 different cells to match the criteria. One is for the item, one is for the type of material and one is for the length of the item. My material type and item are drop down lists from the same data sheet. My length though is just formatted to show the inch sign. Otherwise I put in the data myself. Any help would be greatly appreciated.
Bookmarks