2.77K viewsFormulas and Functions

Dear Support,

Could you help me on the function Lookup using the Category Text?

I am sending you a simple model. he objective is that the Matrix1 should receive only the values for April of prod1, prod3, and prod5.

Rui Duarte



Certainly, I would recommend using the ‘select’ function in this case.

Select has similar functionality of lookup, but is more powerful in that you can surround your select statements with SUM and other functions and the data can be in any order.

I have posted a second version of the file. Please let me know if you have any questions.