I have a list of multiple rows of data that I need to generate a result based on the selection of 2 cells.
The data on the left is a portion of the data. On the right is the selection options, the FEEDER and TYPE choices are dropdown lists of the FEEDER list on the left.
If I select 3W300AL and EMT on the right table the result in SIZE should be 2.5, if I select IMC it should be 3, if I select LT it should be 3, etc.
I have tried nested XLOOKUPs, INDEX/MATCH and can't seem to get the result I want.
The data on the left is a portion of the data. On the right is the selection options, the FEEDER and TYPE choices are dropdown lists of the FEEDER list on the left.
If I select 3W300AL and EMT on the right table the result in SIZE should be 2.5, if I select IMC it should be 3, if I select LT it should be 3, etc.
I have tried nested XLOOKUPs, INDEX/MATCH and can't seem to get the result I want.