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,
Luca
Answers
-
Can you please put together in Excel and share the source and target modules and it's dimensions for better understanding.
0 -
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!
0