Microvellum Community

How to get lookuptable value using row and column

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!

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      MVU eLearning



      Grow Your Knowledge
      Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


        Follow us on:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.