Hi Guys,
I think I am just missing something with my formula.
In table 1 (sheet3) I have a table with my code in Column B and different sizes with its values from Column D through H
In Table 3 (Sheet1) I have a table where I need to match the code and the size to return the value from that size column
So if I have a code in table 3 with a small size, I need it to return the value from the corresponding code in Table1 but the value in the Small column, if the same code has a Large size I need it to return the value from the Large column
The formulas I tried to use:
=INDEX(Table1[[XS]:[XL]],MATCH(1,(Table1[[#All],[Article]]=[@Article])*(Table1[[#Headers],[XS]:[XL]]=[@Size]),0))
=XLOOKUP(1,([@Article]=Table1[Article])*([@Size]=Table1[[#All],[XS]:[XL]]),Table1[[XS]:[XL]])
Any suggestions or help, please?
I think I am just missing something with my formula.
In table 1 (sheet3) I have a table with my code in Column B and different sizes with its values from Column D through H
In Table 3 (Sheet1) I have a table where I need to match the code and the size to return the value from that size column
So if I have a code in table 3 with a small size, I need it to return the value from the corresponding code in Table1 but the value in the Small column, if the same code has a Large size I need it to return the value from the Large column
The formulas I tried to use:
=INDEX(Table1[[XS]:[XL]],MATCH(1,(Table1[[#All],[Article]]=[@Article])*(Table1[[#Headers],[XS]:[XL]]=[@Size]),0))
=XLOOKUP(1,([@Article]=Table1[Article])*([@Size]=Table1[[#All],[XS]:[XL]]),Table1[[XS]:[XL]])
Any suggestions or help, please?