Hi.

Could someone please help me with trying to get the value from a look up table which is basically combining the VLOOKUP and the HLOOKUP, if that makes sense.

So, I have a table for board materials where the rows are the board name and the columns are the board size, the values are then the handling codes for the each board name/size.

I've been trying to use the MATCH function but with no luck. Below being my example

=MATCH(LookUpTableMaterials,VLOOKUP(Sheet_Material_1,LookUpTableMaterials,1,FALSE),HLOOKUP(Sheet_Material_1_Board_Size_1,LookUpTableMaterials,1,FALSE))

Any ideas?

Thanks in advance!