Cannot Lookup nor Firstnonblank, how can I solve this?


Hi All,

I have been trying to come up with a solution to this problem;

I need to let the "belong to fab category?" boolean be checked whenever a cost element list item belong to that particular fab category (e.g. "direct labor")

Now, the user has been already giving me this information in another module:

However, the list of this module is different from mine, featuring a combination of cost center and cost element. As you can see though, the cost element (as I have it in the first module) appears in the last column.

I was wondering if there was a way to pull out the Fab Category from this last module and push it into the first one, because there seem to be all the informaiton I need but apparently no lookup and not even firstnonblank formula can help, as far as I know (given that the same cost element can be matched to multiple cost centers and multiple fab categories).

Many thanks,




  • Dikshant

    Can you please put together in Excel and share the source and target modules and it's dimensions for better understanding.

  • @Dikshant Hope it's clearer now:


    rows: cost center | cost element list

    columns: FAB Category, Cost Center, Cost Element line items

    pages: none


    rows: cost element list

    columns: fab category list

    pages: belongs to fab category? line item

  • Dikshant

    Hey, that helps. I got the requirement now, and I built the solution as well. Let me know if you have any questions about the same.

    Blueprint View:

    Using my all time favorite function, ANY😉 I try to use it all the places…

    Let me know if there are any questions!

  • @Dikshant seems to be working! thanks a lot!!